Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
Am new to Qlikview and I need a clarification on the below scenario request to help me out in this.
I want to load multiple QVDs at a time into qlikview file.
Below is the attachment for your reference.
Thanks in advance.
R'gs
Sattish.
You can use use wildcards to load QVD's
So try something like
Load * from D:\Practice\QVD\*.qvd (qvd) ;
Although having relooked at your picture they may well all have different structures so this may not give you want you want.
Please clarify your question.
what is your problem in particular? because it is normal to add multiple QVDs with multiple load statements, of course they cannot run in parallel, they will run one after one.
If we have suppose single QVD like Customers.qvd in the same path
Then my script as follows like this
load *
from D:\Practice\QVD\Customer.qvd(qvd);
But in the same scenario
I want to read all the QVDs at a time into qlikview.
Hello Sattish,
/* If you are worried about synthetic keys during load, and want to deactivate table associations, turn on qualify
Qualify *;
*/
FOR EACH vFile IN FileList('D:\Practice\QVD\*.qvd')
Let vFilename = Subfield(Subfield('$(vFile)','\',-1),'.',1);
//isolates the QVD filename from the full path
[$(vFilename)]:
NOCONCATENATE LOAD * FROM [$(vFile)] (qvd);
NEXT
Sattish,
What you can do at script side , set link like below:
Set vQVD = '...........................\QV_QVD'; (link where your all qvds are available)
And later you can do this , taking your example:
load *
from D:\Practice\QVD\Customer.qvd(qvd);
Thanks,
AS