Joining 3 tables and keeping all available rows

[Kat92]

Hi,

I have 3 tables that are created through group by from previous tables and want to join them.

However, although I have 2 common dimensions I need to bring not only the common rows but all the available rows from each table. I.e below

Table1

1	Name1
3	Name3
5	Name5

Table 2

1	Adress1
2	Adress2

Table 3 

1	City1
5	CIty5
7	City7

And the output would need to be as per below

1	Name1	Adress1	City1
2		Adress2
3	Name3
5	Name5		CIty5
7			City7

Thanks in advance

[Aditya_Chitale · Accepted solution]

Try outer joining to first  table.

Refer:

Outer | Qlik Sense on Windows Help

Regards,

Aditya

[Kat92]

Hi Aditya,

Initially I was trying to outer join in a new table but hit to an error.

Outer joining directly to first table works great.

Thanks a lot!