Joining QVDs

[#1]

Hi Guys,

Can I join two (or more QVDs) using SQL type queries.

Example:

I have two QVDs which have one common column using which i would like to do a outer join and fetch some columns from both the qvds. Is it possibe? Some thing like the one below!!!

LOAD

a.X, b.X, a.Y,a.Z

from abc.qvd (qvd) a LEFT OUTER JOIN def.qvd (qvd)

ON a.X=b.X

Regards,

Clara

[#2]

hello Clara

try something like this

Result:

Load
X,
Y,
Z,
from abc.qvd (qvd)

Left outer join(Result)

Load
X,
W,
R
from def.qvd (qvd);

It should work

Talha

[stephencredmond · Accepted solution]

Hi Clara,

Yes, you can join. The syntax is slightly different:

Table:
Load
 X,
 Y,
 Z
From abc.qvd (qvd);
Left Join Load
 X,
 D,
 E,
 F
From def.qvd (qvd);

You don't need to specify which fields to join on, QlikView will automatically join on any matching fields.

Regards,

Stephen

[#4]

Thanks Stephen... It worked...

Thanks Talha for responding...

Regards,

Clara