This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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.
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);
View solution in original post
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'
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.
In QlikSense you need to use a folder connection: FileList('LIB://MyFolder/*.qvd')