Loading multiple QVD's

[#1]

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.

[Anonymous]

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.

[maleksafa]

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.

[#4]

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.

[evan_kurowski]

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

[amit_saini]

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