https://community.qlik.com/t5/Talend-Studio/Unpivot-Source-Excel-File/m-p/2365887#M129447 <P>Hi </P><P>Take a look at tNormalize component, I think this component can achieve your requirement. </P><P>https://help.talend.com/r/en-US/8.0/processing/tnormalize-tfileinputdelimited-tlogrow-tlogrow-normalizing-data-standard-component-this</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Tue, 12 Dec 2023 02:32:21 GMT Anonymous 2023-12-12T02:32:21Z https://community.qlik.com/t5/Talend-Studio/Unpivot-Source-Excel-File/m-p/2365886#M129446 <P>Hi Everyone, </P><P></P><P></P><P>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.</P><P>I have a source file with the following format below </P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="069U1000000xxKDIAY.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139040i96EA13DAD9F5DDDD/image-size/large?v=v2&amp;px=999" role="button" title="069U1000000xxKDIAY.png" alt="069U1000000xxKDIAY.png" /></span></P><P></P><P></P><P>And would like to have a format like this below. </P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="069U1000000xxDlIAI.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155901i63333D3A7919104A/image-size/large?v=v2&amp;px=999" role="button" title="069U1000000xxDlIAI.png" alt="069U1000000xxDlIAI.png" /></span></P><P></P><P></P><P>Any help will be highly appreciated.</P><P>Thank you</P> Fri, 15 Nov 2024 21:11:19 GMT https://community.qlik.com/t5/Talend-Studio/Unpivot-Source-Excel-File/m-p/2365886#M129446 Meco-MDP-Qlik 2024-11-15T21:11:19Z https://community.qlik.com/t5/Talend-Studio/Unpivot-Source-Excel-File/m-p/2365887#M129447 <P>Hi </P><P>Take a look at tNormalize component, I think this component can achieve your requirement. </P><P>https://help.talend.com/r/en-US/8.0/processing/tnormalize-tfileinputdelimited-tlogrow-tlogrow-normalizing-data-standard-component-this</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Tue, 12 Dec 2023 02:32:21 GMT https://community.qlik.com/t5/Talend-Studio/Unpivot-Source-Excel-File/m-p/2365887#M129447 Anonymous 2023-12-12T02:32:21Z