how to transpose columns into rows dynamically at one job

[sakura99]

Hi there.

So I have been trying to transpose columns into rows at one job.

the data looks like this:

I already pass the tnormalize, but I need it runs like single job.

Any idea to write it in tJavaFlex or TExtractRegexFields?

Thank you.

[Anonymous]

Hello,

Could you please have a look at this article to see if it is what you are looking for?

https://community.talend.com/s/article/Converting-columns-to-rows-ok7sf

Best regards

Sabrina

[sakura99]

unfortunately, it doesn't what I expected.