Qlik Community

Qlik Community Help Discussions

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

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

2 Replies
Not applicable

Left Join.

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

Not applicable

Left Join.

Thank you Felim.  It Worked.