Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliksensetd
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 (1)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Maybe like attached!

View solution in original post

4 Replies
Frank_Hartmann
Master II
Master II

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

 

qliksensetd
Contributor II
Contributor II
Author

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

Frank_Hartmann
Master II
Master II

Maybe like attached!

qliksensetd
Contributor II
Contributor II
Author

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!