Join tables and fill missing fields

[qliksensetd]

Hi All,

I have 3 tables(table 1, table 2, table 3). See screenshot.

I want to create one table(table 4). It is not possible to join directly table 1 and table 2 as they don't share the same key.

In table 2 you can find a related key to table 1 and one to table 3.  Also table 2 contains columns which I want in the result table.

Next to that I want in the result table that for each records all fields are filled with the related data(from table 1 & 2).

Can you pls help me with this. I am struggling since yesterday.

Many thanks,

Tarik

[Frank_Hartmann]

How to get Paris in Final Table if its not mentioned in the Source Tables??

[qliksensetd]

I have updated the screenshot. Table1.ID1 is related to Table2.ID1. Table2.ID2 is related to Table3.ID1.

[Frank_Hartmann · Accepted solution]

Maybe like attached!

[qliksensetd]

Hi Frank,

Issue solved thanks to you. I was looking for a join solution, while loading is sufficient. How simple it sometimes can be.

Thanks!