Skip to main content
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);