concatenate(table_name) table not found

[#1]

I am trying to add rows to a table that is successfully loaded on a previous tab in the script.  At this point in the script I have connected to a different data source.  I get "table not found" on the following:

Concatenate(Order)

Load

.....

Resident tempTable;

tempTable:

Load

....

SQL Select * from temptable;

Both Order and tempTable are sucessfully loaded.

Suggestions?

Thank you

[#2]

witch table is not found? tempTable?

[#3]

table not found

Concatenate(Order)

[#4]

If you add an exit script before Concatenate(Order).....

reload and see the model. Is Order exists? with O in uppercase?

Eva

[#5]

Yes the table Order exists and has data in it and yes Order with capital O.

I'm stumped

[#6]

Ok... annother way... did you try to Load just 1 or 2 fields in the concatenate statement?

[#7]

Yep, that is how I started.

Concatenate(Order)

load

   CustomerKey,

   LabelKey

Resident TempTable;

TempTable:

Load

     CustomerKey,

     LabelKey;

SQL SELECT * from tempTable;

error

Table not found

Concatenate(Order)

LOAD

    .....

[#8]

I have made some progress but am still having issues.  I changed the order of things to the following:

TempTable:

Load

...

;

SQL Select * from tempTable;

Load

(a list of the same fields as Order to that there is an automatic concatenation)

Resident TempTable;

TableA:

Load

(some addtional fields from TempTable)

Resident TempTable;

Drop Table TempTable;

now I am getting a random error from the next tab in my script.

Everything works just fine if I comment out the second Load above which is concatenating to Order.

[Anonymous]

Without reading all of the messages I would guess that your problem is Automatic Concatenation.

Keep in mind that QlikView will automatically concatenate tables with exactly the same field structure.

So if you load one table with fields A, B & C and then later load another table with fields A, B & C the new table will automatically be concatenated to the end of Table 1, that is unless you specify NoConcatenate before loading the second table.

Makes sense?

[#10]

is it normal? you have got tempTable and TempTable