Transformation Process
Last updated
Last updated
The "Core" of the application is the ability to transform files. Let's take a quick easy look at how we can do this in Transforms
The Transform tab at the top contains every section we need to drag and drop our input files, maps, lookups, segment rules, or even quickly hop over to the database I/O tab to read in data from a database.
The top tab contains everything you need to perform a transform. The fastest way to assign all of your files is to drop them into the "Quick Drop Zone". It will read and determine the file types, and assign them to the various input slots.
If you'd like to assign them manually, you can either click the blue box associated with the input files, or maps to quickly take you to the source and options screens. Or simply click the gear or document icons located on the left side of the screen in the collapsed container.
These screens allow you to drag-and-drop your input file, maps file, lookup file, and segmentation file to the appropriate inputs. You may also click the box to open a file select dialog.
To perform a transformation, you need at least an input file assigned. If you do not have a map assigned, the file will be auto-identified and auto-mapped. Please see the page for more info on this process.
Once your files are assigned, click the "TRANSFORM" button to begin the transformation process. You won't have to wait long to get the results
Once the transformation process is complete you will see a grid with the results. This grid will contain the target file, reports, and any associated files that may be downloaded alongside them.
You may also ZIP all of the files and download that instead using the ZIP button.
The Import button will use the output of your transformation as the input data to load into a SQL database. Please note, this relies on you having a valid connection string in your defined.
