topic Left Join. in Water Cooler

Left Join.

Thu, 24 May 2012 10:07:57 GMT

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,

FROM

[..\Table 1.xlsx]

(ooxml, no labels, table is Sheet1);

Table_2:

LOAD A,

FROM

[..\Table 2.xlsx]

(ooxml, no labels, table is Sheet1);

Left Join.

Thu, 24 May 2012 10:48:18 GMT

Table_1:

LOAD A AS Primary_Key,

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,

FROM

[..\Table 1.xlsx]

(ooxml, no labels, table is Sheet1);

CONCATENATE (Table_1)

LOAD A,

FROM

[..\Table 2.xlsx]

(ooxml, no labels, table is Sheet1);

Left Join.

Thu, 24 May 2012 12:10:05 GMT

Thank you Felim. It Worked.