Join the tables

[YHC]

Hi All,

I want to join four tables as following screenshot. I want to pick the rows in TABLE2, 3, 4  if their IDs are match with TABLE1, and left join those qualified table. How should I do?

I tried this:

[TABLE1 left join TABLE2 left join TABLE3 left join TABLE4 ],  but it didn't show the product0002 and 0003. Also, don't use WHERE ID='0001''0002''0003', cause the original dataset is too big to type all the ID manually.

Thanks!

[Tanish]

Hello,

Can you try joining Table2, Table3 and Table4 First with Left join  then you can write Right join for Table1. 

[TABLE2 left join TABLE3 left join TABLE4   Right join TABLE1 ]

Hope this will work....🙂👍

[Diego_780]

Hi YHC,

I tried to copy your tables by inline loads in qlikview, and by doing this order and this type of Joins, I can get your result:

The result is what you expected:

But I´m pretty sure this only works with this data.

If you need help with more data let me know if I can try to assist you

Best Regards,

Diego