We use the community version of TOS.
My requirement is to transpose the following input:
Sorry about the formatting of the sample tables.
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.