Transformations Editor


[ view full screenshot image ]


The Transformations Editor includes a comprehensive list of functions for transforming your data. Conditions can be tested, records and be skipped, changes can be conditionally made, formatting and content can be updated--the list goes on. The handy Function Chooser window lets you decide what function is needed and instructs you how to use each one. The Step Notes box lets you document each transformation step that you create (so you can remind yourself of the "what" and "why"). The Preview area of the Transformations window lets you incrementally view the transformations you have made to your data, one step at a time. It also lets you browse through your records to ensure that your transformations consistently have the desired effects.

This screenshot shows usage of the function "Split Up Name Field", and it reveals how myDataChameleon can save you a lot of time and technical effort in your data manipulation activities. The input file contains the spouse's full name but the destination table needs to receive that name broken out into first/middle/last name components. The "Split Up Name Field" function "transforms" the original full name field and from it creates new, derived/artificial fields that are the components of the full name: Title, FirstName, MiddleName, LastName, Suffix. Any derived/artificial fields that you create using transformation functions can be further processed as if they were fields that originally came from the data source.