load data from different qvds based on name

[hpad]

Hi,

  I have daily qvd files with date in the qvd name. for 10 different dates, I want to loop thru and load from these 10 files. How can do that  ? 

[stevejoyce]

You can use a wildcard in the FROM statement in load statement

table:

load

*

From [<path>\<qvdBaseName>*.qvd] (qvd);

[hpad]

There is a date  in the qvd name. So, I want to load specific files based on the date. I have a SQL that returns some dates. Based on the return values from the SQL, I want to load only those Qvds.