Load data from multiple excel files with multiple excel sheets

Anonymous — Mon, 09 Oct 2017 11:51:29 GMT

The following question is from the thread:

Load Multiple excel sheets using For loop

I have been trying to figure out a way to only load new files by using this script. After a lot of trial and error I came up with the script below. This works for all files except for the last, i.e. it loads through all the files without adding any data but it does load data from the last file even though it should not.

the MaxsystemTime used below is derived from a timestamp on one of the sheets in the excel files, i..e it does not exist on all sheets which stops me from using it in the WHERE clause (I think....)

NewData:

LOAD

'' AS Data.Field1,

'' AS Data.Field2

AutoGenerate(0);

FOR index = vStartSheetNumber TO vEndSheetNumber

Set ErrorMode = 0;

Concatenate(NewData)

LOAD

FROM C:\Temp\Qlik\Data*.xlsx

(ooxml, embedded labels, table is [Datasheet$(index)])

WHERE Filetime() > '$(MaxSystemTime)';

Any ideas or alternate ways of only loading new data while loading from Mlutiple sheets?

topic Load data from multiple excel files with multiple excel sheets in QlikView

Load data from multiple excel files with multiple excel sheets