Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Transform columns into rows

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.

Labels (1)
2 Replies
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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:

0683p000009M4EP.png

 

Thanks