In this article you will learn how to convert rows to columns.
This procedure was written with:
Talend verified this procedure to be compatible with:
In this procedure the following source file will be converted:
The rows are converted to columns as follows:
Create a simple Job as seen below:
The tPivotToColumnsDelimited is used to convert the rows to columns. It requires at least three columns in the input schema: the Pivot column, the Aggregation column and one or more Group keys.
This Job is also available in the attachments list.
Execute the Job. The output file will be as follows:
It is not currently possible to output the result as a data flow that doesn't require an output file. If necessary you can use a tFileInputDelimited component to read the result back into the next Job from the output file created by tPivotToColumnsDelimited.