Qlik ignores table names

[#1]

Hi, I cannot understand why Qlik concatenates tables completely ignoring (cancelling) table names. In the following example, Qlik ignores the table name "Table_2", because it concatenates all in Table_1.

Table_1:

load * inline [

f1, f2

1, 2

3, 4

];

Table_2:

load * inline [

f1, f2

44, 55

66, 77

];

[swuehl · Accepted solution]

There is auto-concatenation happening, if both tables show same fields, use NOCONCATENATE LOAD prefix:

able_1:

load * inline [

f1, f2

1, 2

3, 4

];

Table_2:

NOCONCATENATE

load * inline [

f1, f2

44, 55

66, 77

];