Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I am very much new to Qlik. I have seen tables join syntax using Left OUTER Join RIGHT JOIN etc. Can we use Oracle Join Syntax which is something like below
table1.column = table2.column(+)
If yes then can i have specimen code for it.
Regards,
Zahid Rahim
With Qlikview you don't need to specify the column names to join on, Qlikview will automatically join on common field names between the tables
if you still want to use your existing SQL statement then use a SQL SELECT clause as below for example
Tab1:
Load *;
SQL SELECT Order, Item, Date
FROM TABLENAME WHERE <Your condition>
Can i join more tables in a script with join conditions something link below.
table1.column = table2.column(+)
table1.column = table3.column(+)
Hi,
If I correctly understood the code Oracle (I'm not an specialist in Oracle, the Internet is in the help).
Source code Oracle looks something like this
select * from TABLE1 "table1", TABLE2 "table2"
where
table1.column = table2.column(+)
and table1.column = table3.column(+)
The same code of Qlik script (tables сonsider as internal) will be like this
Table:
LOAD
column
Resident table1;
Left Join
LOAD
column
Resident table2;
Left Join (Table)
LOAD
column
Resident table3;
You can not use directly this (above) expression in Qlik.
Regards,
Andrey