topic Re: implicit and explicit Concatenate in QlikView

implicit and explicit Concatenate

Fri, 08 May 2015 10:10:13 GMT

Hi,

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

Thanks

Manju

Re: implicit and explicit Concatenate

Peter_Cammaert — Fri, 08 May 2015 10:14:14 GMT

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.

Re: implicit and explicit Concatenate

Anonymous — Fri, 08 May 2015 10:21:20 GMT

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

Table1:

Load

Name,

Country

from abc ;

Table2:

Load

Name,

Country

from XYZ;

it will auto concatenate and will get one table Table1.

explicit :

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