https://community.qlik.com/t5/Talend-Studio/How-to-read-an-excel-file-with-multi-row-headers/m-p/2262212#M42745 <P>Hi Everyone,</P> <P>&nbsp;</P> <P>I have an excel file with multiple rows of headers as in the example below. How do I handle this? I need to figure a way to import this later such that I can perform a trow split later. I'd really like for it to have "Januar Sales Un. YTD 2018", "Januar Sales Un. YTD 2017", etc., all in one.&nbsp;</P> <P>&nbsp;</P> <P>Thank you!</P> <P>Michael</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture 1.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4eh.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134935iA34177236E07BF34/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4eh.png" alt="0683p000009M4eh.png" /></span></SPAN></P> Tue, 16 Apr 2019 14:55:35 GMT Anonymous 2019-04-16T14:55:35Z https://community.qlik.com/t5/Talend-Studio/How-to-read-an-excel-file-with-multi-row-headers/m-p/2262212#M42745 <P>Hi Everyone,</P> <P>&nbsp;</P> <P>I have an excel file with multiple rows of headers as in the example below. How do I handle this? I need to figure a way to import this later such that I can perform a trow split later. I'd really like for it to have "Januar Sales Un. YTD 2018", "Januar Sales Un. YTD 2017", etc., all in one.&nbsp;</P> <P>&nbsp;</P> <P>Thank you!</P> <P>Michael</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture 1.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M4eh.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134935iA34177236E07BF34/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M4eh.png" alt="0683p000009M4eh.png" /></span></SPAN></P> Tue, 16 Apr 2019 14:55:35 GMT https://community.qlik.com/t5/Talend-Studio/How-to-read-an-excel-file-with-multi-row-headers/m-p/2262212#M42745 Anonymous 2019-04-16T14:55:35Z https://community.qlik.com/t5/Talend-Studio/How-to-read-an-excel-file-with-multi-row-headers/m-p/2262213#M42746 <P>You may have a 2 steps approach (this is the easier):</P><P>- 1rst tFileInputExcel to get the 2nd line from the input file (header = 1, limit = 1), place the result into a tHashOutput for future reuse of the values</P><P>- 2nd&nbsp;tFileInputExcel to get the rest of the file (header = 2)</P><P>&nbsp;</P> Tue, 16 Apr 2019 19:19:05 GMT https://community.qlik.com/t5/Talend-Studio/How-to-read-an-excel-file-with-multi-row-headers/m-p/2262213#M42746 TRF 2019-04-16T19:19:05Z