Discussion Board for collaboration on QlikView Scripting.
Can I join two (or more QVDs) using SQL type queries.
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!!!
a.X, b.X, a.Y,a.Z
from abc.qvd (qvd) a LEFT OUTER JOIN def.qvd (qvd)
Go to Solution.
Yes, you can join. The syntax is slightly different:
Table:Load X, Y, ZFrom abc.qvd (qvd);Left Join Load X, D, E, FFrom def.qvd (qvd);
You don't need to specify which fields to join on, QlikView will automatically join on any matching fields.
try something like this
LoadX,Y,Z,from abc.qvd (qvd)
Left outer join(Result)
LoadX,W,Rfrom def.qvd (qvd);
It should work
Thanks Stephen... It worked...
Thanks Talha for responding...