Noconcatinate .

[#1]

Can anybody tell me what is the use of noconcatinate and how it is used withan simple example.

Thanks.

[michael_maeuser]

QlikView automatically concatenates tables if 2 or more tables have the same fields (names).

with noconcatenate you can avoid this.

e.g. you have 2 tables

SalesLine:

load

Item
Amount

Purchase Line:

load

Item

Amount

thouse two tables would be concatenated by qv if you don´t use the command noconcatenate

[#3]

Thank you very much Michael.

[er_mohit]

@@see in help of qlikview software@

The NoConcatenate prefix forces two tables with identical field sets (i.e. they would normally be Concatenation automatically) to be treated as two separate internal tables.

The syntax is:

noconcatenate( loadstatement | selectstatement )

Example:

Load A,B from file1.csv;

noconcatenate load A,B from file2.csv;

[narender123]

Hi,

Suppose you have two table.

Table1:

Load

a,

b,

c

from table1;

noconcatenate

Table2:

Load

a,

b

from Table2;

This will give give the result as same in two different table but bydefault join between a and b of both table.

if you replaced noconcatenate with concatenate then this will give the result in One Table ie Table1 with field a,b,c .

means merge with Table 1 .

Better if you do this with a simple example by youeself.

Thanks

[#6]

Thank you ALL.