Load mutiple QVD where title QCD contain date

jmialoundama — Sat, 16 Nov 2024 19:45:07 GMT

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

Re: Load mutiple QVD where title QCD contain date

dwforest — Tue, 05 Nov 2019 17:53:48 GMT

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

topic Load mutiple QVD where title QCD contain date in App Development

Load mutiple QVD where title QCD contain date

Re: Load mutiple QVD where title QCD contain date