Discussion Board for collaboration related to QlikView App Development.
I have around 30 qvd files in a folder, I need to load it all in a single block.
Is it possible.
Go to Solution.
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);
Something like this:
Set vFolder = 'C:\QVD';
for each File in filelist($vFolder& '\*.qvd')
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
You could also do:
Load * from $(vDirectory)\*.qvd;
Be advised that you loose debugging capability if you do so.
Thanks a lot... it works..
@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?
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'