qlikview - joins & concatenate

[dinesh999]

difference b/w joins & concatenate?

[Vegar]

In short.

LOAD A, B, C FROM Table1;

JOIN LOAD A, B, D, E FROM Table2;

With join you are doing a lookup on common field names and values and where these match you add the unique columns where the values match.

LOAD A, B, C FROM Table1;

CONCATENATE LOAD A, B, D, E FROM Table2;

With Concatenate you just add new rows to the concatenated table.

[Vegar]

Read this blog post by @rwunderlich from 2009.  Understanding Join and Concatenate 

[Channa]

concatenate will do the union of two or many tables

join do join

[Brett_Bleess]

Let's see if we can get some further links on here for you and others to look over that may help!

Design Blog posts:

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

https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569

Help links:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Scr...

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/LoadData/conc...

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Script...

I think that about covers it, hopefully this gets you what you need if you are still trying to sort things out here.

Regards,
Brett