Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

Maybe like attached!

View solution in original post

4 Replies
Master II
Master II

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

 

Contributor II
Contributor II

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

Master II
Master II

Maybe like attached!

View solution in original post

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!