Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to achieve this
//sql
select
table_1.a,
table_2.b,
table_3.c,
table_4.e
from table_1, table_2, table_3, table_4
where
table_1.p = table_2.p and
table _2.q = table _3.q and
table _3.r = table _1.r and
table_4.s = table_2.s
I know a way to achieve this qlikview using tables but I want to achieve this using qvds as the data is huge.
Hi Urmil,
QVD is just storage of data in tabular format, so there is no change in syntax of joining table vs joining qvd.
Example:
Table:
Load
X,
Y,
Z
From abc.qvd (qvd);
Left Join Load
X,
D,
E,
F
From def.qvd (qvd);
Depending on the join that you want to perform, you can replace the join key word(LEFT,RIGHT...,)
-Siva
Hi
It depends what do you want to do, but first of all, the key fields (to do the join) must to have the same name. And second, depends do you want to do. Automatically, this four tables will be linked by Qlik (associative logic) but if you need yo make joins (and to have one single table at the end), you will have several options
Here do you have an example: Understanding Join, Keep and Concatenate