Transpose column to row and rows to column

Anonymous — Sat, 16 Nov 2024 02:46:05 GMT

Hi all,

I have a CSV file which has 19 columns & 8356 rows. So total no. of records are 158,764.

I want to transpose/change all 19 columns into rows & all 8356 rows into columns along with an additional column which represents sequence starting from 1 for no. of rows.

So my output should have now 8357 columns(one additional column for sequence) & 19 rows.

Since I am new in Talend, Kindly help me with screenshots of the components and methods used.

Thanks

topic Transpose column to row and rows to column in Talend Studio

Transpose column to row and rows to column