topic in what situation used NoConcatenate ? in QlikView

in what situation used NoConcatenate ?

Fri, 18 Oct 2013 02:36:49 GMT

Hi All

I aware NoConcatenate is opposite of Concatenate, can some one share with me when to use it ?

Re: in what situation used NoConcatenate ?

Fri, 18 Oct 2013 02:40:37 GMT

The NoConcatenate prefix forces two loaded tables with identical field sets to be treated as two separate internal tables, when they otherwise would be automatically be concatenated.

Concatenate

If two tables that are to be concatenated have different sets of Fields, Concatenation of two tables can still be forced with the Concatenate prefix. This statement forces concatenation with an existing named table or the latest previously created Logical Table.

see this at Qlikview Help app

Re: in what situation used NoConcatenate ?

jagan — Fri, 18 Oct 2013 04:25:55 GMT

Hi Paul,

If you two tables with the same fields, then both the tables are joined when you load, and both the tables are dropped when we drop one table. To prevent this NoConcatenate is used.

For Example

Table1:

LOAD * INLINE [
A
B
];
Table2:
LOAD * INLINE [
A
B
];

For this script when you execute only one table is created and all records in table 2 are concatenated into Table1.

Table1:

LOAD * INLINE [
A
B
];
Table2:

Noconcatenate
LOAD * INLINE [
A
B
];

For the above script, the two tables are separately created.

Hope this helps you.

Regards,

Jagan.