topic How to make combine sheets into one table for same Excel Filename in QlikView https://community.qlik.com/t5/QlikView/How-to-make-combine-sheets-into-one-table-for-same-Excel/m-p/1195194#M879202 <HTML><HEAD></HEAD><BODY><P>I have various Excel files in the disk.</P><P>In one of the Excel sheet i have Day field and in another excel sheet i have date ( within same excel filename).</P><P>i need to combine into one table and date as an key.&nbsp; </P><P></P><P>Pls suggest the looping with filename and concatenation logic. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z How to make combine sheets into one table for same Excel Filename https://community.qlik.com/t5/QlikView/How-to-make-combine-sheets-into-one-table-for-same-Excel/m-p/1195194#M879202 <HTML><HEAD></HEAD><BODY><P>I have various Excel files in the disk.</P><P>In one of the Excel sheet i have Day field and in another excel sheet i have date ( within same excel filename).</P><P>i need to combine into one table and date as an key.&nbsp; </P><P></P><P>Pls suggest the looping with filename and concatenation logic. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-make-combine-sheets-into-one-table-for-same-Excel/m-p/1195194#M879202 2020-11-25T16:16:04Z Re: How to make combine sheets into one table for same Excel Filename https://community.qlik.com/t5/QlikView/How-to-make-combine-sheets-into-one-table-for-same-Excel/m-p/1195195#M879203 <HTML><HEAD></HEAD><BODY><P>There would be many discussions on these in the community, try searching, below link is one of them</P><P><A href="https://community.qlik.com/docs/DOC-4452">Load Multiple excel sheets using For loop</A></P></BODY></HTML> Thu, 13 Oct 2016 19:01:18 GMT https://community.qlik.com/t5/QlikView/How-to-make-combine-sheets-into-one-table-for-same-Excel/m-p/1195195#M879203 rupamjyotidas 2016-10-13T19:01:18Z