I have a folder which contain 365 qvds and I want to load only 3 columns from each qvd but 2 columns from the latest days contain my fields. How I can do this? I would have in future 365 qvds and by year more and more.
I only need 3 columns from my qvds:
ID,
Banding
QVDDate
ex: The qvds are all in the same folder.
test01012018.qvd
test20180101.qvd
test20180102.qvd
....
test20181126.qvd ( this qvd contain my new fields Banding and QvdDate)
test20181127.qvd ( this qvd contain my new fields Banding and QvdDate)
test20181128.qvd ( this qvd contain my new fields Banding and QvdDate)
The easiest way would be just to use two different folders - each one each different data-structure - and then using two appropriate adjusted load-statements.
Of course there are solutions possible, for example to catch each qvd-file with a filelist() loop and then checking which fields are available and then to branch into different load-statements or creating one on the fly.
