topic Re: Combine several excel sheet in only one in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Combine-several-excel-sheet-in-only-one/m-p/1364034#M2895 <HTML><HEAD></HEAD><BODY><P>Take a look on this: <A href="https://community.qlik.com/docs/DOC-7860">Loading Multiple Excel Sheets Dynamically along with file name and sheet name</A> and you could add recno() and rowno() to this loading to identify each of your records.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 04 May 2017 15:19:30 GMT marcus_sommer 2017-05-04T15:19:30Z Combine several excel sheet in only one https://community.qlik.com/t5/Connectivity-Data-Prep/Combine-several-excel-sheet-in-only-one/m-p/1364033#M2894 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm new on Qlik sense and I do not have a huge developper background let's say...</P><P></P><P>I've a double issue while loading an excel file. The excel file contains 70 sheets named "ID1, ID2, ID3...". In each sheet, there are several information about the ID.</P><P></P><P>1) I would like to create a column in each sheet with the ID number. (Same ID number for every rows in the sheet)</P><P>2) I would like to combine all those sheets into only one.</P><P></P><P>The expected result is to have all the sheet combined in one with a column that tell to which ID this rows is related. Hope it is clear.</P><P></P><P>I assume that it is possible through the script but I've no idea on how to start...</P><P>May some of you have any ideas ?</P><P></P><P>Thanks a lot.</P><P>Alexis</P></BODY></HTML> Thu, 04 May 2017 09:43:38 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Combine-several-excel-sheet-in-only-one/m-p/1364033#M2894 2017-05-04T09:43:38Z Re: Combine several excel sheet in only one https://community.qlik.com/t5/Connectivity-Data-Prep/Combine-several-excel-sheet-in-only-one/m-p/1364034#M2895 <HTML><HEAD></HEAD><BODY><P>Take a look on this: <A href="https://community.qlik.com/docs/DOC-7860">Loading Multiple Excel Sheets Dynamically along with file name and sheet name</A> and you could add recno() and rowno() to this loading to identify each of your records.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 04 May 2017 15:19:30 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Combine-several-excel-sheet-in-only-one/m-p/1364034#M2895 marcus_sommer 2017-05-04T15:19:30Z