Difference between concatenate and Nonconcatenate

[#1]

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?

[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]

Hi Pankaj,

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

Andy

[Anonymous]

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

[#5]

Thank You Sunny.

[#6]

See the example:

[gilbertomedeiro]

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