Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Something like this:
Set vFolder = 'C:\QVD';
for each File in filelist($vFolder& '\*.qvd')
load * from [$(File)] (qvd);
next File
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
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
You could also do:
Table1:
Load * from $(vDirectory)\*.qvd;
Be advised that you loose debugging capability if you do so.
Dion
Hello Gysbert,
Thanks a lot... it works..
Regards
Chriss
@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
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'
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
In QlikSense you need to use a folder connection: FileList('LIB://MyFolder/*.qvd')