Loading Multiple QVD from a folder

[0li5a3a]

Hi all,

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)

Can someone help me?

[marcus_sommer]

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.

- Marcus