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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

Load mutiple QVD where title QCD contain date

Hi,
want to load multiple QVDs. I have several QVDs starting in 2012 and I would like to load the QVD only for the last two years. That is the QVDs of 2018 and 2019. Here is a piece of code that I started. thank you in advance

LET vFilePath ='lib://QVD_ExactBI/TEST/DE1';FOR EACH file in FileList('$(vFilePath)/*.csv'); // Loops each excel file in the given Folder
LET vFileDate = Date(Left(right(file,28),8)); // Gets the year portion from the filename
LET vMaxDate = Rangemax(vFileDate, vMaxDate); // Gets the max year for every iteration
NEXT

Labels (1)
1 Reply
dwforest
Specialist II
Specialist II

just add a load statement
LOAD *
FROM [$(vFilePath)] (txt, codepage is 28591, embedded labels, delimiter is ',', msq);