topic Looping load script in QlikView https://community.qlik.com/t5/QlikView/Looping-load-script/m-p/225860#M78125 <HTML><HEAD></HEAD><BODY><P>Hi Dayna,</P><P>I hope this gives an idea</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />temp_table:// for concatenate<BR />noconcatenate LOAD * INLINE [<BR /> Temp<BR /> 1<BR />];<BR /><BR />for each vFilename in filelist ('ExcelTables_*')<BR /><BR />concatenate(temp_table)<BR />load<BR /> *<BR />from<BR />$(vFilename)<BR />(biff, embedded labels, table is Blad1$);<BR /><BR />next<BR /><BR /><BR />// drop dummy-field<BR />drop field Temp;<BR />Define VFilename as a variable with the location of the excelsheets<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P></P><P>Regards</P><P>Sravan</P><P></P></BODY></HTML> Thu, 21 Apr 2011 11:37:50 GMT 2011-04-21T11:37:50Z Looping load script https://community.qlik.com/t5/QlikView/Looping-load-script/m-p/225859#M78124 <HTML><HEAD></HEAD><BODY><P>Hello All!</P><P>I will have a SQL database which stores the location of 100's of excel sheets (all with the same/similiar formatting).</P><P>I want QlikView to loop through these sheets and load them into my application. I have no idea how to go about this tho! Please help!</P><P>KInd Regards,<BR />Dayna</P></BODY></HTML> Thu, 21 Apr 2011 11:22:09 GMT https://community.qlik.com/t5/QlikView/Looping-load-script/m-p/225859#M78124 Dayna 2011-04-21T11:22:09Z Looping load script https://community.qlik.com/t5/QlikView/Looping-load-script/m-p/225860#M78125 <HTML><HEAD></HEAD><BODY><P>Hi Dayna,</P><P>I hope this gives an idea</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />temp_table:// for concatenate<BR />noconcatenate LOAD * INLINE [<BR /> Temp<BR /> 1<BR />];<BR /><BR />for each vFilename in filelist ('ExcelTables_*')<BR /><BR />concatenate(temp_table)<BR />load<BR /> *<BR />from<BR />$(vFilename)<BR />(biff, embedded labels, table is Blad1$);<BR /><BR />next<BR /><BR /><BR />// drop dummy-field<BR />drop field Temp;<BR />Define VFilename as a variable with the location of the excelsheets<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P></P><P>Regards</P><P>Sravan</P><P></P></BODY></HTML> Thu, 21 Apr 2011 11:37:50 GMT https://community.qlik.com/t5/QlikView/Looping-load-script/m-p/225860#M78125 2011-04-21T11:37:50Z