Column to Row transpose in Talend

[Anonymous]

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.

[akumar2301]

This might help

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

[Anonymous]

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

.

[akumar2301]

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