topic Re: Re: auto concatenate & force concatenate pls explain? in QlikView

auto concatenate & force concatenate pls explain?

Thu, 12 Sep 2013 06:10:41 GMT

what is auto concatenate & force concatenate pls explain?

Re: auto concatenate & force concatenate pls explain?

Thu, 12 Sep 2013 06:14:17 GMT

HI,

If you have tables with same columns then it will concatenate automatically. In such situation we have to use no concatenate explicitly.

Force concatenate is to join two tables into a single one.

Please see the help in qlik view you can find some more info

Re: auto concatenate & force concatenate pls explain?

vikasmahajan — Thu, 12 Sep 2013 06:26:29 GMT

http://community.qlik.com/thread/87721

Please refer.

Vikas

Re: auto concatenate & force concatenate pls explain?

Thu, 12 Sep 2013 06:31:47 GMT

i have idea about force concatenate

can u pls explain what is auto concatenate is there any difference b/w auto & normal concatenate

Re: auto concatenate & force concatenate pls explain?

Thu, 12 Sep 2013 06:35:27 GMT

Hi,

Both auto concatenate and force concatenate are same but the thing is in auto concatenate is done by qlikview when it's find the same fields in both table even though you don't want to concatenate so that time you have to use the no concatenate keyword explicitly

Re: auto concatenate & force concatenate pls explain?

Thu, 12 Sep 2013 06:45:53 GMT

Hi,

Auto Concatenation happens when there are common/similar fields in two tables, it is done by default (by qlikview) irrespective of wherther you want it or not. If concatenation is not needed then you have to use the "No Concatenate" word explicitly between the tables.

Forced Concatenation is when the fields in tables are same but you still need them to be concatenated, for this you need to use concatenate word explicitly. It appends the rows of one table to another.

Basically Auto & Forced concatenation have the same function, difference being : Auto concatenation is done by qlikview by default and forced concatenation can be done explicitly.

Hope this helps!

Re: auto concatenate & force concatenate pls explain?

Thu, 12 Sep 2013 08:22:50 GMT

Thanks for rly

can share any work file with example regarding auto & force concatenate if possible

Re: Re: auto concatenate & force concatenate pls explain?

Thu, 12 Sep 2013 08:48:13 GMT

Hi ,

PFA a sample file.

Also below are few cents i found in reference manual :

Automatic Concatenation

If the field names and the number of fields of two or more loaded tables are exactly the same, QlikView will

automatically concatenate the content of the different statements into one table.

Example:

load a, b, c from table1.csv;

load a, c, b from table2,csv;

The resulting internal table has the fields a, b and c. The number of records is the sum of the numbers of records

in table 1 and table 2.

Rules:

The number and names of the fields must be exactly the same.

The order of the two statements is arbitrary.

Forced Concatenation

If two or more tables do not have exactly the same set of fields, it is still possible to force QlikView to concatenate

the two tables. This is done with the concatenate prefix in the script, which concatenates a table

with another named table or with the last previously created table.

Example:

load a, b, c from table1.csv;

concatenate load a, c from table2,csv;

The resulting internal table has the fields a, b and c. The number of records in the resulting table is the sum

of the numbers of records in table 1 and table 2. The value of field b in the records coming from table 2 is

NULL.

Rules:

The names of the fields must be exactly the same.

Unless a table name of a previously loaded table is specified in the concatenate statement the concatenate

prefix uses the last previously created table. The order of the two statements is thus not arbitrary.