Left Join.

[#1]

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);

[#2]

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);

[#3]

Thank you Felim.  It Worked.