<< Click to Display Table of Contents >> Navigation:  How do I? > Handle column name/order changes in inputs

If you have a .transform file that you want to run multiple input files through (perhaps with a different input file each month, via the command line from a script, or as a batch process) you need to be aware of differences in column name and column order in the input files.

 

To change the file being used by an input, select the input item and change the file location in the Right pane (e,g, by clicking the '...' browse file button).

 

Columns in the same order, but with different names

Easy Data Transform references columns in inputs by their position (e.g. 3rd column from the left) not their column name. So differences in column names (e.g. first column is called "id" in input 1 and "UniqueID" in input 2) are not generally an issue.  But you need to be careful if you are using the Stack transform with Align columns by set to Header name, as this will reorder columns by name. If you want to always output the same column names, regardless of the input column names, you could use a Rename Cols transform to set the column names explicitly.

 

Columns with the same names, but in a different order

Use a schema for the input.

 

Columns with the same names, but with one or more columns missing

Use a schema for the input.

 

Columns with the same names, but with one or more extra columns

Use a schema for the input.

 

Columns with different names, in a different order

Easy Data Transform can't handle this automatically. But you can create a new .transform and use Reorder Cols and/or Rename Cols transforms to output to a new file with the correct column names/ordering. You can then input this to the original .transform.