In this final section we look at the data load. Here we will use the same tUnpivot row component to transpose the actual row data into columns and assign the column values from the column_config file.

In this we will use the same file name from the tFileList component. the only change we will apply is to add Default value as “Null”to the columns as follows

Screenshot 2019-06-21 at 3.52.54 PM

Then we will use Primary Columns as our unpivot columns.

Screenshot 2019-06-21 at 3.43.47 PM

 

In the first tMap, we map FileName and the pivot columns as follows

Screenshot 2019-06-21 at 3.44.35 PM

In Second tMap, we will use the Variables to write the column order expressions.

Screenshot 2019-06-21 at 3.58.57 PM

This also has the look up from the column_config file joining with FileName and MeasureName.

and the final file looks as below

Screenshot 2019-06-21 at 4.01.18 PM

Please share your comments feedback below.

Please find the job I created along with the files HERE.

Dynamic Schema Main          Create Column Mapping        Unpivot          Manage Order