Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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