Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Join tables and fill missing fields

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

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Maybe like attached!

View solution in original post

4 Replies
Highlighted
Master II
Master II

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

 

Highlighted
Contributor II
Contributor II

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

Highlighted
Master II
Master II

Maybe like attached!

View solution in original post

Highlighted
Contributor II
Contributor II

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!