Load all QVDs in a folder with only 1 load statement

[niha]

 Hello,

I need answer of this question.

how to:

1. Load all QVDs in a folder with only 1 load statement

[Lisa_P]

The best way would be to use a for loop to iterate through all the QVDs in the folder.

[niha]

Thanks. Can you give any examples or link.

[Lisa_P]

Actually, the simplest way is to load all with wildcards.

LOAD
*
FROM [lib://QVDFiles/*.qvd]
(qvd);

[niha]

Thanks Lisa,

is  [lib://QVDFiles/*.qvd] is path of QVD folder? Can you please elaborate a little?

LOAD
*
FROM [lib://QVDFiles/*.qvd]
(qvd);

[Lisa_P]

I created a connection named QVDFiles pointing to a folder location and this is extracting all the QVDs from that folder.

[niha · Accepted solution]

great!