Discussion Board for collaboration related to QlikView App Development.
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;
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?
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
FOR EACH vDay IN '1', '20', '25'
nb: not sure, whether digits need to be in apostrophes.