Loading all QVD’s in a folder

Sometimes short articles are the best. You don’t need lots of time to get a nice idea or concept.

Do you want to load multiple QVD’s from a folder?

Here is the code:

Set vFolder = '.';

FOR each File in filelist(vFolder& '\*.qvd')
LOAD * FROM [$(File)] (qvd);

For a more simple solution to this problem you could also use:

LOAD * FROM .\*.qvd (qvd);

Hope this helps you guys a bit.