topic Re: Left Join help in QlikView

Left Join help

stevejones1 — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Left Join help

adityaakshaya — Sat, 23 Jun 2018 07:57:01 GMT

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

Re: Left Join help

arvind_patil — Sat, 23 Jun 2018 08:19:56 GMT

Hi Steve,

At the time of joining use table name like below:

Table1:

Left join(Table1)

Table3:

Thanks,

Arvind Patil

Re: Left Join help

rubenmarin — Sat, 23 Jun 2018 13:07:13 GMT

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;

Re: Left Join help

qlikviewwizard — Sun, 24 Jun 2018 06:09:01 GMT

Hi,

Can you provide us some sample data?