topic How in QlikView

How

subbareddykm — Tue, 29 Dec 2015 06:06:49 GMT

How to use multiple Left Joins.

For Exp:

I have 7 Tables

Table1:

Left Join

Table2:

>>>If I use

Left Join (Table2)

Table5:

Its showing error Table Not found(Table2)

If i use Left keep its working But its giving Sythatic keys.

CAn any one tell me how to solve this ?

oknotsen — Tue, 29 Dec 2015 10:23:05 GMT

You can only join with tables that you have already loaded.

So if you load table1 followed by table2, you can join table2 with table1 but you can not join table1 with table2.

Anonymous — Tue, 29 Dec 2015 10:28:57 GMT

Table1:

Left Join

Table2:

>>>Rename table2 to table1

Left Join (Table1)

Table5:

Now it will not throw any error because earlier you were joinint to table2 which is already join to table1

MarcoWedel — Tue, 29 Dec 2015 12:34:52 GMT

Hi,

Table1:

Left Join

Table2:

only creates Table1, so there is no Table2 to join with in your subsequent load.

hope this helps

regards

Marco