4 Replies Latest reply: Jan 27, 2014 8:55 AM by Fabrice Aunez RSS

    Syntax to Join

      Hi

       

      I want to join two tables which have a common column name, please tell me syntax for it.

       

      Thanks in advance

       

      Sagar

        • Re: Syntax to Join
          Celambarasan Adhimulam

          Hi,

               You don't need to join it.Qlikview join it internally.

               If you trying to make a single table then use with this.

               Inner Join(TableName1)

               Load

                    *

               Resident TableName2;

          Note:TableName1 is already loaded table which you need to join.

          Hope it helps

          Celambarasan

          • Re: Syntax to Join
            jagan mohan rao appala

            Hi,

             

            You have various types of joins.  They are Left, Right, Outer and Inner.  You can see the examples of those

                

                 Left Join(TableName1)

                 Load

                      *

                 Resident TableName2;

             

                

                 Right Join(TableName1)

                 Load

                      *

                 Resident TableName2;

             

               

                 Inner Join(TableName1)

                 Load

                      *

                 Resident TableName2;

             

                 Outer Join(TableName1)

                 Load

                      *

                 Resident TableName2;

             

            Hope this helps you.

             

            Regards,

            jagan.

            • Re: Syntax to Join
              neetha P

              Hi Sagar,

               

              Qlikview Joins tables two ways:

              ·Auto Concatenate

              ·Force Concatenate

               

              Auto Concatenate:

                   1. When QlikView finds multiple tables with the exact same fields, it combines them into one table automatically 

                   2. Create empty fields (dummy fields) using null() function for missing ones in each table

               

              Sales:

              Load

                Year,

                Month,

                [Customer Number],

                [Sales Amount],

                Null() as [Budget Amount]

              FROM Sales;

               

              Budget:

              Load

                Year,

                Month,

                [Customer Number],

                Null() as [Sales Amount],

                [Budget Amount]

              FROM Budget;

               

              Force Concatenate:

                      1.    Joins two tables with different fields

               

              Sales:

              Load

                Year,

                Month,

                [Customer Number],

                [Sales Amount],

                FROM Sales;

               

              Budget:

              Concatenate (Sales)

              Load

                Year,

                Month,

                [Customer Number],

                [Budget Amount]

              FROM Budget;

               

               

              This post explains joins and concatenate http://community.qlik.com/message/416223#416223

              • Re: Syntax to Join

                Hi,

                 

                I have written a doc on LOAD where the JOIN is explained:

                http://community.qlik.com/docs/DOC-5698

                 

                It should help you.

                 

                Fabrice