Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load Script - Daily Files

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?

2 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

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

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptControlStatem...

prieper
Master II
Master II

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.