2 Replies Latest reply: May 24, 2012 8:10 AM by qlikviewj.r RSS

    Left Join.

      Hi their.  I'm new to the "Join" in qlikview and just will be needing help on how to do a left join.  I have created a basic example but not to sure on how to script in the edit script. Thank You.

       

      Table_1:

      LOAD A,

                B

      FROM

      [..\Table 1.xlsx]

      (ooxml, no labels, table is Sheet1);

       

       

      Table_2:

      LOAD A,

                B,

                C

      FROM

      [..\Table 2.xlsx]

      (ooxml, no labels, table is Sheet1);

        • Left Join.
          Felim Shanaghy

          Table_1:

          LOAD A AS Primary_Key,

                    B

          FROM

          [..\Table 1.xlsx]

          (ooxml, no labels, table is Sheet1);

           

          LEFT JOIN (Table_1)

          LOAD A AS Primary_Key,

                    B AS B_T2,

                    C AS C_T2

          FROM

          [..\Table 2.xlsx]

          (ooxml, no labels, table is Sheet1);

           

          Your Table_1 will now have A, B, B_T2, C_T2 as columns.  If however you just want to append C so Table 1 and the other 2 fields are common use

           

          Table_1:

          LOAD A,

                    B

          FROM

          [..\Table 1.xlsx]

          (ooxml, no labels, table is Sheet1);

           

          CONCATENATE (Table_1)

          LOAD A,

                    B,

                    C

          FROM

          [..\Table 2.xlsx]

          (ooxml, no labels, table is Sheet1);

          • Left Join.

            Thank you Felim.  It Worked.