topic Different between Concatenate and Join in the QV Script in QlikView

Different between Concatenate and Join in the QV Script

Wed, 16 May 2012 17:55:06 GMT

Can anybody explain the different between Concatenate and Join in the QV script when loading from two QVDs

Thanks,

Different between Concatenate and Join in the QV Script

Wed, 16 May 2012 20:59:16 GMT

Hi,

You can look at a Rob Wunderlich Post:

http://qlikviewnotes.blogspot.com/2009/11/understanding-join-and-concatenate.html

Regards,

Yigal.

Different between Concatenate and Join in the QV Script

Anonymous — Thu, 17 May 2012 00:01:27 GMT

Badr,

Very briefly:
The purpose of JOIN is to add columns to a table. As a side effect, there could be additional rows. To join properly, the tables must have at least one common field.
The purpose of CONCATENATE is to add rows to a table. As a side effect, there could be additional columns.

Regards,
Michael

Different between Concatenate and Join in the QV Script

Thu, 17 May 2012 04:52:36 GMT

Joining needs a common field where Concatenate works more like append.

Table: A Table B: Table C:

A B C A D E Left Join: A B C D E

1 0 0 1 5 6 1 0 0 5 6

1 0 1 1 7 3 1 0 1 5 6

0 1 0 1 0 0 7 3 ... and so on

Concatenate would give you. Table C:

A B C D E

1 0 0 - -

1 0 1 - -

0 1 0 - -

1 - - 5 6

1 - - 7 3

Hope that makes it more clearer.

Different between Concatenate and Join in the QV Script

janardhan — Thu, 17 May 2012 05:00:00 GMT

Hi ,

Concatenate allows duplicate values , but join doesnt.

Re: Different between Concatenate and Join in the QV Script

Fri, 29 Apr 2016 10:46:23 GMT

Add a image: