Load Script - Daily Files - Qlik Community

Anonymous · ‎2017-11-10

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 · ‎2017-11-10

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 · ‎2017-11-10

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.