Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between concatenate and Nonconcatenate

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

13     A3

15     A5

Can any one explain it in detail?

6 Replies
sunny_talwar

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

awhitfield
Partner - Champion
Partner - Champion

Hi Pankaj,

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

Andy

Anonymous
Not applicable
Author

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

Not applicable
Author

Thank You Sunny.

Not applicable
Author

See the example:Presentation1 - PowerPoint.jpg

gilbertomedeiro
Contributor III
Contributor III

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).ConcatenateAndNoConcatenate.png