Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load multiple qvd files

Hello Friends,

I have around 30 qvd files in a folder, I need to load it all in a single block.

Is it possible.

Regards

Chriss

1 Solution

Accepted Solutions
Highlighted

Re: Load multiple qvd files

Oops, tripped up again by variable variety. No $-expansion for vFolder in this case. Try instead:

Set vFolder = 'D:\New Leads\QVD';

for each File in filelist(vFolder& '\*.qvd')

     load *  from [$(File)] (qvd);

next File


talk is cheap, supply exceeds demand
7 Replies

Re: Load multiple qvd files

Something like this:

Set vFolder = 'C:\QVD';

for each File in filelist($vFolder& '\*.qvd')

     load *  from [$(File)] (qvd);

next File


talk is cheap, supply exceeds demand
Not applicable

Re: Load multiple qvd files

Hello Gysbert,

Thanks for your reply, as what you said I tried like the following. but its taking different qvd from the root folder.

what I have to give in the filelist and I don't know where I am making a mistake, could you please help me

Set vFolder = 'D:\New Leads\QVD';

for each File in filelist($vFolder& '\*.qvd')

     load *  from [$(File)] (qvd);

next File

Regards

Chriss

Highlighted

Re: Load multiple qvd files

Oops, tripped up again by variable variety. No $-expansion for vFolder in this case. Try instead:

Set vFolder = 'D:\New Leads\QVD';

for each File in filelist(vFolder& '\*.qvd')

     load *  from [$(File)] (qvd);

next File


talk is cheap, supply exceeds demand
Not applicable

Re: Load multiple qvd files

You could also do:

Table1:

Load * from $(vDirectory)\*.qvd;

Be advised that you loose debugging capability if you do so.

Dion

Not applicable

Re: Load multiple qvd files

Hello Gysbert,

Thanks a lot... it works..

Regards

Chriss

Not applicable

Re: Load multiple qvd files

@gwassenaar your script helped me to read qvd in a folder with many files. I am trying to figured out the need for  '\* 

to me seems an escape for ' symbol but I am not sure. Could you provide an hit on this?


Thank you

Carmine

Re: Load multiple qvd files

It's not an escape. It's necessary to create a full path to the files you want to load.

If vFolder is 'D:\New Leads\QVD' then vFolder & '\*.qvd' gives 'D:\New Leads\QVD\*.qvd'


talk is cheap, supply exceeds demand
Community Browser