👾Transformation Process

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.

File Assignements

Auto File Assignment

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.

Manual File Assignment

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.

Transformation

Transform Your File

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 File Identification 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 👍

Results View

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 Profile defined.