Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. 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

 

Tags (2)
Labels (2)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: Join tables and fill missing fields

Maybe like attached!

View solution in original post

4 Replies
Highlighted
Master II
Master II

Re: Join tables and fill missing fields

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

 

Highlighted
Contributor II
Contributor II

Re: Join tables and fill missing fields

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

Highlighted
Master II
Master II

Re: Join tables and fill missing fields

Maybe like attached!

View solution in original post

Highlighted
Contributor II
Contributor II

Re: Join tables and fill missing fields

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!