In this article you will learn how to convert columns to rows.
This procedure was written with:
In this procedure the following source file will be converted:
The columns become rows as follows:
Install the custom component tUnpivotRow. Please refer to this page to learn how to install a custom component.
Create a simple Job as follows:
Because both columns (Pivot_key and Pivot_value) are read only in the tUnpivotRow component, you must change the column names in tMap to map to the target schema.
This Job is also available in the attachments list.
Execute the Job and tLogRow (display results with table model) will output the following result to the console: