My requirement is to transpose rows to columns. I am using tPivotToColumnsDelimited. But this currently allows aggregation of one column. I have to transpose the row data of three columns, where one column is the common pivot column for the other two columns.
So I have used this component twice, in the hope to merge the two resultant files (CSV) into one output later.
Ideally I could use tMap component to merge the two CSV files. But I do not have a predefine schema, as the data in the files is not static. So I am unable to define a schema for input source to tMap.
Can someone please suggest a way forward? I’ll be grateful for your help.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema