Loading Multiple QVD from a folder

0li5a3a — Sat, 16 Nov 2024 05:07:16 GMT

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?

Re: Loading Multiple QVD from a folder

marcus_sommer — Wed, 28 Nov 2018 16:48:12 GMT

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

topic Loading Multiple QVD from a folder in QlikView

Loading Multiple QVD from a folder

Re: Loading Multiple QVD from a folder