This section is where we need to transpose the row structure of the config file to columns so that we can use it as a lookup table later.

We use tFile delimited with Column values ranging from Column0 to ColumnN with a key column added as filename.

Screenshot 2019-06-21 at 1.26.40 PM

 

Then use tUnpivotRow as below

Screenshot 2019-06-21 at 1.29.35 PM

Use tMap to map the data to final config file as follows

Screenshot 2019-06-21 at 1.30.38 PM

The final file (column_config_final in my case) would look like this

Screenshot 2019-06-21 at 1.37.16 PM

Next is   Manage Order 

Dynamic Schema Main         Create Column Mapping        Load data