Load N Weekly QVD Files in an app

s2016 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm looking to load N number of Weekly QVDs from a directory. Files are named as Data_YYYYMMDD.qvd with a new file created on each Monday of the week.

e.g.) Data_20181126.qvd, Data_20181119.qvd, Data_20181112.qvd, Data_20181105.qvd, etc.

I need to load the latest 66 weeks in my app.

Any suggestions?

Re: Load N Weekly QVD Files in an app

prieper — Tue, 27 Nov 2018 08:22:09 GMT

aircode might be:
FOR EACH vL.File IN FILELIST ('MyDirectory\Data_*.QVD')
IF(DATE#(LEFT(RIGHT([vL.File], 12), 8), 'YYYYMMDD') >= TODAY() - (66*7) THEN
Data: LOAD * FROM [$(vL.File)] ....;
END IF
NEXT vL.File

topic Re: Load N Weekly QVD Files in an app in QlikView

Load N Weekly QVD Files in an app

Re: Load N Weekly QVD Files in an app