Script query

Tue, 19 Mar 2013 13:33:34 GMT

Hi All,

I was wondering if there was a way that i could perform a load from an xls file based on its created date?

Currently, we load from an xls based on the filename, here is how i have done it..

Let vOORFilename = 'C:\qvd\Test_'&LEFT(TODAY(),2)&MID(TODAY(),4,2)&'.xls';

That looks for an xls with a filename of Test_todays date (Date/Month).

That works well for us apart from when the xls has failed to get generated over the weekend. This means that on a Monday we have to re run the xls for each day it has failed (usually Sat/Sun/Mon) then reload our application 3 times, changing the filenames of the xls's each time to ensure they are all loaded in.

I was hoping for a way to load in the 3 xls's the same time so the script will look for the file created date and if more than 1 is present then it would loop through them until all have been read in.

Can anyone help please?

Re: Script query

alexandros17 — Tue, 19 Mar 2013 13:48:21 GMT

This is the code to loop more xls files .... add the correct conditions!

Hope it helps

let path_Alles = '..\..\qlik\\myFiles*.xlsx';

for each File in filelist (path_Alles)

IF(condition) then

LOAD
.....
FROM $(File) (ooxml, embedded labels, table is Display)

ENDIF

next File

topic Re: Script query in QlikView

Script query

Re: Script query