topic Re: Join the tables in App Development

Join the tables

YHC — Wed, 19 Jul 2023 07:04:47 GMT

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!

Re: Join the tables

Tanish — Wed, 19 Jul 2023 07:28:33 GMT

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....🙂👍

Re: Join the tables

Diego_780 — Wed, 19 Jul 2023 08:07:57 GMT

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