Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zahidrahim_ocp
Contributor

Join Table Syntax

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

4 Replies
vinieme12
Esteemed Contributor II

Re: Join Table Syntax

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>

zahidrahim_ocp
Contributor

Re: Join Table Syntax

Can i join more tables in a script with join conditions something link below.

table1.column = table2.column(+)

table1.column = table3.column(+)

ahaahaaha
Honored Contributor

Re: Join Table Syntax

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

arvind_patil
Valued Contributor II

Re: Join Table Syntax

Hi zahid,

Please refer the below link It will help you:

qlikview join vs sql joins

Thanks,

Arvind Patil