Discussion board where members can get started with Qlik Sense.
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.
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
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 = table3.column(+)
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
Left Join (Table)
You can not use directly this (above) expression in Qlik.
Please refer the below link It will help you:
qlikview join vs sql joins