Transpose columns to rows and rows to column

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hello,

Could you please give us more information about your job requirement? Elaborating your case with an example with input and expected output values will be preferred

Best regards

Sabrina

[Anonymous]

Hi,

I have a file which has a total of 19 columns. I have attached a sample of that file which has 9 columns (ORG_STATUS_ID, ORG_STATUS_CATEGORY,........, PENDING) for your reference. These columns contain many rows.

so I want to transpose all 9 columns to rows and all these rows to columns. Also, I want to number these rows from 1,2,3,.......and so on as described in output screenshot I have attached. 

Input:

Expected output:

Please describe me with the components to be used along with screenshots and their mappings.

Thanks