Transform Column names to Rows with corresponding values

[Anonymous]

Hello, 

I have a problem to which i have no solution for now. My source file looks like this:

Date,A,B,C
01-01-2019 ,1,2,3
02-01-2019,1,2,3

and i want to transform it to become something like this 

A,01-01-2019,1
A,02-01-2019,1
B,01-01-2019,2
B,02-01-2019,2
C,01-01-2019,3
C,02-01-2019,3

Is there a way to do this in Talend? 

Thanks,

[Anonymous]

Hello,

You can achieve it via talend data Integration perspective.

Could you please let us know if this community knowledge article helps?

https://community.talend.com/t5/Migration-Configuration-and/Converting-columns-to-rows/ta-p/21658?co...

Best regards

Sabrina

[Anonymous · Accepted solution]

Hello, 

Thank you for your reply Sabrina, 
I've been struggling installing plugins in my TOS-DI v7.1, so i couldn't work with the addon in your link. 
Alternatively, i used the method proposed by praveenvm in the following topic, which uses a tJavaFlex component, and it worked like a charm. 

Best regards, 
Amine

[Anonymous]

Hello,

Thanks for your feedback.

Using custom code in a tJavaFlex component would be better. We will update this article to give more solutions for that.

Best regards

Sabrina