Join

[RaulSouza]

I know that basically Join and Concatenate do the same thing, but when to use concatenate and when to use Join? What would be the best use case for each element?

[trdandamudi]

They do not do the same thing. Please look at the below link and hope that helps:

https://community.qlik.com/t5/New-to-QlikView/What-is-difference-between-concatenate-join/td-p/74800...

[Ricardo_Gerhard]

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/combine-tables...