Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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