Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.