implicit and explicit Concatenate

[#1]

Hi,

  Can any One Explain What is implicit and explicit Concatenate in qlikview with some Example if possible

Thanks

Manju

[Peter_Cammaert]

An Implicit concatenate will happen when QlikView thinks that a subsequent LOAD statement produces a similar table as the previous one. An optional name for the new table will be ignored. This operation can be avoided by using the NOCONCATENATE prefix.

An Explicit concatenate is a LOAD statement that is preceded by the CONCATENATE or CONCATENATE (TableName) prefixes. With these prefixes, you explicitly tell QlikView to add all new rows to the most recently created or to an older existing RESIDENT table.

[Anonymous · Accepted solution]

implicit : If your both table structure is exactly same then QlikView  automatically concatenate both the table and make single table

Ex

Table1:

Load 

Name,

Country

from abc ;

Table2:

Load 

Name,

Country

from XYZ;

it will auto concatenate and will get one table Table1.

explicit :

Ex

Table1:

Load 

Name,

Country ,

ZipCode

from abc ;

Concatenate

Table2:

Load 

Name,

Country

from XYZ;

You need to explicitly concatenate both the table with Keyword 'Concatenate '

Thanks

BKC