Left Join help

[stevejones1]

Here is the load statement

Table 1 :

Load

Col 1

Col 2

Col 3

Resident A

Left Join

Table 2 :

Load

Col 1

Col 4

Col 5

Resident B

Left Join

Table 3 :

Load

Col 1

Col 6

Col 7

Resident C

Left Join

Table 4:

Load

Col 3

Col 8

Col 9

Resident D;

This is my script , i want to make sure that Table 3 is joined based on Col 1 from Table 1 NOT Table 2 .. how do i make sure ?

And also based on structure above on what column Table 4 is joined ?

[adityaakshaya]

Hi Steve,

The script you have written will always take col1 from Table1.

However to answer your question, you can add table name after left join like below 

Table1:

Load col1, col2, col3 resident TableA

Left join(Table1)

Load col1, col4, col5 resident TableB

Regards 

Akshaya

[arvind_patil]

Hi Steve,

At the time of joining use table name like below:

Table1:

..

..

Left join(Table1)

Table3:

..

..

Thanks,

Arvind Patil

[rubenmarin]

Hi Steve, you can create a field to check with exist(), ie:

Table 1 :

Load

Col 1

Col 2

Col 3

Resident A;

Left Join

Table 2 :

Load

Col 1

Col 1 as chkCol1

Col 4

Col 5

Resident B;

Left Join

Table 3 :

Load

Col 1

Col 6

Col 7

Resident C

Where not exists(chkCol1, Col1);

DROP Field chkCol1;

Left Join

Table 4:

Load

Col 3

Col 8

Col 9

Resident D;

[qlikviewwizard]

Hi,

Can you provide us some sample data?