topic Re: Loading multiple QVD's in QlikView

Loading multiple QVD's

Tue, 02 Sep 2014 13:54:20 GMT

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.

Re: Loading multiple QVD's

Anonymous — Tue, 02 Sep 2014 14:00:58 GMT

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.

Re: Loading multiple QVD's

maleksafa — Tue, 02 Sep 2014 14:01:55 GMT

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.

Re: Loading multiple QVD's

Tue, 02 Sep 2014 14:26:17 GMT

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.

Re: Loading multiple QVD's

evan_kurowski — Tue, 02 Sep 2014 14:33:58 GMT

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);

Re: Loading multiple QVD's

amit_saini — Tue, 02 Sep 2014 14:49:12 GMT

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,