topic Re: Difference between concatenate and Nonconcatenate in QlikView

Difference between concatenate and Nonconcatenate

Thu, 28 Apr 2016 10:50:57 GMT

I have two tables and I am not getting exact idea that what concatenate do and what non concatenate do ??

Table 1

ID point

11 A1

12 A2

13 A3

14 A4

15 A5

Table 2

ID point

11 B1

11 B2

13 A3

15 A5

Can any one explain it in detail?

Re: Difference between concatenate and Nonconcatenate

sunny_talwar — Thu, 28 Apr 2016 15:42:07 GMT

Concatenate will put them into one table (without any synthetic keys) where as noconcatenate will keep them in two separate tables and will create a synthetic key

Re: Difference between concatenate and Nonconcatenate

awhitfield — Thu, 28 Apr 2016 15:44:51 GMT

Hi Pankaj,

this is explained thoroughly in the QV HELP, have you checked there first?

Andy

Re: Difference between concatenate and Nonconcatenate

Anonymous — Thu, 28 Apr 2016 15:48:52 GMT

...and I must the Qlik Help in general is very good.

Re: Difference between concatenate and Nonconcatenate

Fri, 29 Apr 2016 08:34:41 GMT

Thank You Sunny.

Re: Difference between concatenate and Nonconcatenate

Fri, 29 Apr 2016 10:41:36 GMT

See the example:

Re: Difference between concatenate and Nonconcatenate

gilbertomedeiro — Mon, 09 May 2016 21:04:07 GMT

Hi Pankaj,

Use Concatenate command when you read some tables and need put all of them together in a unique table. Now if you need all of them separated you should use NoConcatenate command which will result in tables separated linked by synthetic keys according the names of the fields in each table. For example, lets use your two tables described in your post: (See the result using both commands).