Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

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

MVP & Luminary
MVP & Luminary

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