Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like attached!
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.
Maybe like attached!
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!