Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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

View solution in original post

10 Replies
Gysbert_Wassenaar

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
Author

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

Gysbert_Wassenaar

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
Author

You could also do:

Table1:

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

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

Dion

Not applicable
Author

Hello Gysbert,

Thanks a lot... it works..

Regards

Chriss

Not applicable
Author

@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

Gysbert_Wassenaar

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
KundanJyothsna
Contributor II
Contributor II

Hi 

 

I am able to load the script and went out successfully with all the qvds in qlikview , but the same code is not working in qliksense.

The "File" variable is fetching as NULL.Can u please suggest anything on this.

 

Regards

Jyothsna Kundan

Gysbert_Wassenaar

In QlikSense you need to use a folder connection: FileList('LIB://MyFolder/*.qvd')


talk is cheap, supply exceeds demand