Looping load script

[Dayna]

Hello All!

I will have a SQL database which stores the location of 100's of excel sheets (all with the same/similiar formatting).

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!

KInd Regards,
Dayna

[#2]

Hi Dayna,

I hope this gives an idea

temp_table:// for concatenate
noconcatenate LOAD * INLINE [
 Temp
 1
];

for each vFilename in filelist ('ExcelTables_*')

concatenate(temp_table)
load
 *
from
$(vFilename)
(biff, embedded labels, table is Blad1$);

next


// drop dummy-field
drop field Temp;
Define VFilename as a variable with the location of the excelsheets

Regards

Sravan