https://community.qlik.com/t5/Talend-Studio/tfileinputexcel-extract-table/m-p/2240309#M27843 <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;wrote: <BR /> <P>With a fixed number of days and products or not?</P> <HR /> </BLOCKQUOTE> <P>Yes, fixed number of days and products<BR /><BR /></P> Thu, 07 Nov 2019 00:49:05 GMT SR2210 2019-11-07T00:49:05Z https://community.qlik.com/t5/Talend-Studio/tfileinputexcel-extract-table/m-p/2240307#M27841 <P>Hi,</P> <P>&nbsp;</P> <P>Can anyone help to provide solution on how do I extract an excel table like in the first image and output them in the form of the second image?&nbsp;</P> <P>&nbsp;</P> <P><STRONG>Excel table:</STRONG></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sample 2d.JPG" style="width: 434px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M7wN.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152139i822828D9FD6C0DD3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M7wN.jpg" alt="0683p000009M7wN.jpg" /></span></SPAN></P> <P>&nbsp;</P> <P><STRONG>Desired output:</STRONG></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="samaple 1d.JPG" style="width: 576px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M7VR.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145507i846DCC096B6D6DF8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M7VR.jpg" alt="0683p000009M7VR.jpg" /></span></SPAN></P> <P>&nbsp;</P> <P>Thank you!</P> Wed, 06 Nov 2019 08:13:43 GMT https://community.qlik.com/t5/Talend-Studio/tfileinputexcel-extract-table/m-p/2240307#M27841 SR2210 2019-11-06T08:13:43Z https://community.qlik.com/t5/Talend-Studio/tfileinputexcel-extract-table/m-p/2240308#M27842 <P>With a fixed number of days and products or not?</P> Wed, 06 Nov 2019 09:17:33 GMT https://community.qlik.com/t5/Talend-Studio/tfileinputexcel-extract-table/m-p/2240308#M27842 TRF 2019-11-06T09:17:33Z https://community.qlik.com/t5/Talend-Studio/tfileinputexcel-extract-table/m-p/2240309#M27843 <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A>&nbsp;wrote: <BR /> <P>With a fixed number of days and products or not?</P> <HR /> </BLOCKQUOTE> <P>Yes, fixed number of days and products<BR /><BR /></P> Thu, 07 Nov 2019 00:49:05 GMT https://community.qlik.com/t5/Talend-Studio/tfileinputexcel-extract-table/m-p/2240309#M27843 SR2210 2019-11-07T00:49:05Z