Left join Qlik Sense

[PrashantRupani]

Hi, I have two dimension tables ( Table 1 and Table 2). I need to  do Table 1 left join Table 2 and show all columns . How do I do this?

Note : The common element between two tables is Col 2.  Just FYI - Col 1 from Dimension table is joined to Col 1 in the fact table.

Table 1: 

Load

Col 1,

Col 2,

Col 3

FROM <qvd file>

Table  2:

Load

Col 2,

Col 4

FROM <qvd file>

[skamath1 · Accepted solution]

Table1: 

Load

Col 1,

Col 2,

Col 3

FROM <qvd file> ;

Left Join (Table1)

Load

Col 2,

Col 4

FROM <qvd file> ;