Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Thanks Stephen... It worked...
Thanks Talha for responding...
Regards,
Clara