topic Re: Transform columns into rows in Talend Studio

Transform columns into rows

Anonymous — Thu, 16 May 2019 09:38:59 GMT

Hello, i am beginner on talend, please could you help me with below query.

I want to duplicate each row of my table 12 times, because I want to include a "month" column in the table, plus another “order” column that will contain the values of the columns "month" of my source file. My input will be from excel file.

Extracted from the source file:

Id_cust	January	February
aaa	20	24
bbb	10	36

Output :

Month	Id_cus	order
January	aa	20
January	bb	10
February	aa	24
February	bb	36

Thanks.

Re: Transform columns into rows

Anonymous — Fri, 17 May 2019 08:59:42 GMT

Hello,

Could you please let us know if this related topic helps?

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

Best regards

Sabrina

Re: Transform columns into rows

Anonymous — Fri, 17 May 2019 12:26:21 GMT

Thank you @xdshi for the link.

I found the solution with the component "tUnpivotRow" via the link that you sent me.

But I have a problem , when I download the component in Talend 7.1, I get a msg “your selection will nest folders” and I can not find the component in the palette:

Thanks