Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Joining QVDs

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

Tags (1)
1 Solution

Accepted Solutions
stephen-a_redmo
Valued Contributor II

Joining QVDs

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

3 Replies
Not applicable

Joining QVDs

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

stephen-a_redmo
Valued Contributor II

Joining QVDs

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

Not applicable

Joining QVDs

Thanks Stephen... It worked...

Thanks Talha for responding...

Regards,

Clara

Community Browser