Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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