I have a folder of daily Open Order extracts in QVD format. The files are named D_OO_YYYYDD. I want to create a table of all dates that are accounted for.
I could Load FileName() From D_OO_*.qvd, but then all the data is ran through for each QVD. Is there a better way?
for each vFile in FileList('your path\*.qvd')
'$(vFile)' as Filelistnames
I thought there had to be a loop! Thanks
Looping will take more time. Instead use First N option. It is faster.
I've just tried it, but I'm finding the loop much quicker. Maybe it's because the data is stored on a networked drive and not my local PC.
Edit: Logically though, it makes more sense that the loop would be quicker as it just has to look at the file names, which it has to do anyway to load the data.
Try First option
Load FileName() From D_OO_*.qvd;
Load FileName() From D_OO_*.qvd
WHERE RecNo() = 1;
Hope this helps you.
This is working for me
From D_OO_*.qvd (qvd);
Both are working, but first one is faster.
Retrieving data ...