topic Re: Difference between Concatenation and Join, when to use what in QlikView

Difference between Concatenation and Join, when to use what

Thu, 10 Jul 2014 17:40:21 GMT

Difference between Concatenation and Join, when to use what

Re: Difference between Concatenation and Join, when to use what

Thu, 10 Jul 2014 17:50:38 GMT

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

Understanding Join, Keep and Concatenate

Re: Difference between Concatenation and Join, when to use what

vardhancse — Thu, 10 Jul 2014 18:04:32 GMT

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

Re: Difference between Concatenation and Join, when to use what

fkeuroglian — Thu, 10 Jul 2014 18:28:29 GMT

Hi, see this

good luck

Fernando

Qlikview Notes: Understanding Join and Concatenate

Understanding Join, Keep and Concatenate

Re: Difference between Concatenation and Join, when to use what

Thu, 10 Jul 2014 18:36:04 GMT

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

Re: Difference between Concatenation and Join, when to use what

maxgro — Thu, 10 Jul 2014 18:48:38 GMT

Re: Difference between Concatenation and Join, when to use what

rwunderlich — Thu, 10 Jul 2014 18:56:55 GMT

Also see

Qlikview Notes: Understanding Join and Concatenate

-Rob

Re: Difference between Concatenation and Join, when to use what

Fri, 11 Jul 2014 05:51:49 GMT

thankyou

Re: Difference between Concatenation and Join, when to use what

Fri, 11 Jul 2014 05:52:01 GMT

thankyou

Re: Difference between Concatenation and Join, when to use what

Fri, 11 Jul 2014 05:52:18 GMT

thankyou