topic Joining QVDs in QlikView

Joining QVDs

Thu, 06 Aug 2009 21:24:03 GMT

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

Joining QVDs

Thu, 06 Aug 2009 22:17:19 GMT

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

Joining QVDs

stephencredmond — Thu, 06 Aug 2009 22:28:34 GMT

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

Joining QVDs

Thu, 06 Aug 2009 22:47:32 GMT

Thanks Stephen... It worked...

Thanks Talha for responding...

Regards,

Clara