Concatenate and Join

[#1]

Hi,

Can any body give me scenariou is that where concatenate is used than join and same as join is useful  than concatenate.

give me business scenariou.

regards

Mahesh T

[Gysbert_Wassenaar]

See this document: Understanding Join, Keep and Concatenate

[#3 · Accepted solution]

Common scenarios are ...

concatenate: two or more tables contain the same fields and you want to bring them together into a single table

left join: two or more tables have a single common key and you want to bring additional fields from one or more child tables into a master table

association (the QlikView default): this is essentially a many-to-many join and very powerful; you will use this option 90% of the time

mapping load and applymap(): similar to a left join but often more efficient in terms of CPU

[#4]

Hi Mahesh,

Please find the attachment copy of document..

[#5]

Thank u.