Unpivot Source Excel File

[Meco-MDP-Qlik]

Hi Everyone,

I would like to know your suggestion on how to handle unpivoting in Talend Studio. I saw some users that have an UnPivot component but I can't see it in my design pallete.

I have a source file with the following format below

And would like to have a format like this below.

Any help will be highly appreciated.

Thank you

[Anonymous]

Hi

Take a look at tNormalize component, I think this component can achieve your requirement.

https://help.talend.com/r/en-US/8.0/processing/tnormalize-tfileinputdelimited-tlogrow-tlogrow-normalizing-data-standard-component-this

Regards

Shong