topic Re: Noconcatinate . in QlikView

Noconcatinate .

Fri, 23 Aug 2013 12:00:14 GMT

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

Thanks.

Re: Noconcatinate .

michael_maeuser — Fri, 23 Aug 2013 12:04:37 GMT

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

Re: Noconcatinate .

Fri, 23 Aug 2013 12:06:42 GMT

Thank you very much Michael.

Re: Noconcatinate .

er_mohit — Fri, 23 Aug 2013 12:10:27 GMT

@@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;

Re: Noconcatinate .

narender123 — Fri, 23 Aug 2013 12:12:03 GMT

Hi,

Suppose you have two table.

Table1:

Load

from table1;

noconcatenate

Table2:

Load

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

Re: Noconcatinate .

Wed, 28 Aug 2013 15:13:20 GMT

Thank you ALL.