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!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables