Difference between Concatenation and Join, when to use what

[#1]

Difference between Concatenation and Join, when to use what

[#2]

There's a few articles on the internet that you can checkout:

Understanding Join, Keep and Concatenate

[vardhancse]

Concatenation:

simply to say:

Table: A

Fields: 123

Table: B

Fields: 456

Concatenation can be when there is no join/common field between the tables:

Result: 123456

Join can be done only when there is common field between 2 tables:

Table: A

Fields: 123

Table B

Fields: 345

Left join(A)

for table B will load related records of A to B based on common field

[fkeuroglian]

Hi, see this

good luck

Fernando

Qlikview Notes: Understanding Join and Concatenate

Understanding Join, Keep and Concatenate

[#5]

The Qlikview script functions JOIN and CONCATENATE can sometimes be used to tackle the same problem, but there are important differences that should be understood.

Concatenate:

Concatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows from the two input tables.

Join:

The join prefix joins the loaded table with an existing named table or the last previously created data table.

The Join prefix may be preceded by one of the prefixes Inner, Outer, Left or Right

[maxgro]

[rwunderlich]

Also see

Qlikview Notes: Understanding Join and Concatenate

-Rob

[#8]

thankyou

[#9]

thankyou

[#10]

thankyou