Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I aware NoConcatenate is opposite of Concatenate, can some one share with me when to use it ?
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.
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.
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
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.