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

Transpose columns to rows and rows to column

Anonymous — Sat, 16 Nov 2024 02:07:35 GMT

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

Re: Transpose columns to rows and rows to column

Anonymous — Thu, 18 Jun 2020 05:05:36 GMT

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

Re: Transpose columns to rows and rows to column

Anonymous — Thu, 18 Jun 2020 08:29:28 GMT

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