This script will load the number of days specified in vDaysToLoad, skipping over any days missing from the folder specified in zPath:
Set vDaysToLoad = 30;
For zDate = Today(1) - vDaysToLoad - 1 To Today(1) - 1
Let zPath = 'PathName\Filename - AU_' & Date(zDate, 'YYYY_MM_DD') & '.csv'
If Alt(FileSize(zPath), 0) <> 0 Then
EXTRACT_DATE AS Date,
FileBaseName() As Source
(txt, unicode, embedded labels, delimiter is ',', msq);
Hi David, did you sort this out somehow?
I am having a similar issue, where I have a daily delta qvd load into a QVDs folder running. From this folder I would like to read only the QVDs, which haven't been read already in my report application. There's a datestamp on the delta QVDfile but it could be that there are several QVD loads per day. I know the delta load logic, but don't know the syntax!
Firstly create a Loaded.qvd with all the loaded delta. Then in report application compare this Loaded.qvd with the delta QVD files in the QVDs folder, and load only the ones which haven't been loaded already. Then add these into Loaded.qvd. Just like dathu.qv proposes.