
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
in what situation used NoConcatenate ?
Hi All
I aware NoConcatenate is opposite of Concatenate, can some one share with me when to use it ?
Accepted Solutions

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
