topic Re: load from 2 qvd in QlikView

load from 2 qvd

amiroh81 — Wed, 10 Dec 2014 09:11:17 GMT

Hi

I Have 2 QVD,

I want to load the first one and in the where option to load fron the secound qvd,

what is the right syntax ?

thanks in advanced

Amir

Re: load from 2 qvd

ashfaq_haseeb — Wed, 10 Dec 2014 09:18:50 GMT

Hi,

Try something like below

Second:

Load

ID,

Filed1,

Field2,

.

.

FieldN

From Second.qvd;

First:

Load

ID,

Filed1,

Field2,

.

.

FieldN

From First.qvd Where Exists(ID,ID);

Regards

ASHFAQ

Re: load from 2 qvd

renjithpl — Wed, 10 Dec 2014 09:40:50 GMT

Hi Amir,

What you want to achieve, basically, this is how a very basic load from two QVD's look like..

pls provide more details if anything else required.. thanks

First_QVD:

LOAD Date,
ID,
Value
FROM
\\..\First.qvd
(qvd);
Second_QVD:
LOAD Name,
ID
FROM
\\..\Second.qvd
(qvd) where ID <> '54321';