This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Maybe like attached!
View solution in original post
How to get Paris in Final Table if its not mentioned in the Source Tables??
I have updated the screenshot. Table1.ID1 is related to Table2.ID1. Table2.ID2 is related to Table3.ID1.
Issue solved thanks to you. I was looking for a join solution, while loading is sufficient. How simple it sometimes can be.