Main difference between Left Join and Join

[Black_Hole]

Hello all,

Working in a QVW's script, I noted that when I used a left join instead of a simple join, the rows of my straight table are duplicated.

So, finally to avoid this issue, I modify by replacing the left join by the join.

But, I wonder if this kind of modification is due to a bad practice in the corpse of my script.

And in addition, if this may have an impact in the calculation result between columns in the script.

Thank you in advance for any explanation about this subject.

[dplr-rn · Accepted solution]

the choice of join depends on your data. and joins in qlik are similar to joins in standard sql. so something like below

use below url to get some more details or check qlik help site

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td...

[Black_Hole]

Hi @dplr-rn ,

Thank you for sharing the link, I will go to see ...

[dplr-rn]

glad to help. mark as answered to close the thread if you dont have any further questions

[Brett_Bleess · Accepted solution]

Just a couple of links from Design Blog area that may help in addition to what Dilip already gave you:

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Feel free to search around there yourself using the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Do not forget to give Dilip credit for help either, if that did help, use the Accept as Solution button on his post to mark things.

Regards,
Brett