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]

I had anonymized my table names for the post so the difference in table names was just a typo.

Thank you all Eva and Johannes - I got this working.  First it was an issue of the order of operation in loading the tem table and then it was an issue with the automatic concatenation. On the next tab I was peeking at the last line of the table to get the date and because of the automatic concatenation that was not a date.

[#3]

could you check the post like "answered"?