4 Replies Latest reply: Jul 12, 2017 5:13 AM by Arvind Patil RSS

    Join Table Syntax

    zahid Rahim

      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

        • Re: Join Table Syntax
          Vineeth Pujari

          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>

            • Re: Join Table Syntax
              zahid Rahim

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

               

              table1.column = table2.column(+)

              table1.column = table3.column(+)

                • Re: Join Table Syntax
                  Andrey Khoronenko

                  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

              • Re: Join Table Syntax
                Arvind Patil

                Hi zahid,

                 

                Please refer the below link It will help you:

                 

                qlikview join vs sql joins

                 

                Thanks,

                Arvind Patil