topic Re: Column to Row transpose in Talend in Talend Studio

Column to Row transpose in Talend

Anonymous — Tue, 02 Apr 2019 20:57:59 GMT

Hi Community,

I am trying to transpose columns to rows in talend.

My source format is

id 201601 201602 201603 ...
1 aa bb cc ...

Column name is depend on date. So I need a automatic way to convert columns into rows.
Expected output is

id date value
1 201601 aa
1 201602 bb
1 201603 cc
. . .
. . .
. . .

I tried to use tUnpivotRow . downloaded zip file and uploaded the extracted folder in
Windows>preferences>Talend>Componenets.
But it is not showing up the palette.
Please help me to design a job as per this requirement.

Re: Column to Row transpose in Talend

akumar2301 — Tue, 02 Apr 2019 21:21:16 GMT

This might help

https://community.talend.com/t5/Design-and-Development/Transpose-Columns-to-Rows/td-p/40077

Re: Column to Row transpose in Talend

Anonymous — Wed, 03 Apr 2019 16:33:14 GMT

Thank you @uganesh

The code worked for me. but the columns which i want to transpose is the date column which will increment monthly.

The code is selecting the fixed number of positions of the columns only.

Is there any way to change it to work dynamically?

after each month, there will be a new column added in the excel

Eg.

Location

Ride name

Apr-16

May-16

Jun-16

Jul-16

Re: Column to Row transpose in Talend

akumar2301 — Wed, 03 Apr 2019 16:40:01 GMT

Try this
https://community.talend.com/t5/Design-and-Development/Convert-Columns-to-Rows/m-p/156769#M95728

Looks like someone else looking for same solution