topic Re: Load Script - Daily Files in QlikView

Load Script - Daily Files

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

So, I've got this super basic question which I wasnt able to Google my way to..

I've got daily files with datestamps in file name.

Now I want to load some of these files, kind of like this:

LET vDay = 1;

NoConcatenate

Table

LOAD

FROM E:\Qlik\Storage\datefile_20*$(vDay).qvd (qvd) ;

So I know how to specify one of the dates. However, I want to import the dates 1, 20 and 25. What is the most effective way to do this?

jpenuliar — Fri, 10 Nov 2017 15:28:49 GMT

Maybe something like below:

Example 1: Loading a list of files

// LOAD the files 1.csv, 3.csv, 7.csv and xyz.csv for each a in 1,3,7,'xyz' LOAD * from file$(a).csv; next

prieper — Fri, 10 Nov 2017 15:31:14 GMT

FOR EACH vDay IN '1', '20', '25'

LOAD

FROM E:\Qlik\Storage\datefile_20*$(vDay).qvd (qvd) ;

NEXT vDay

nb: not sure, whether digits need to be in apostrophes.