topic Re: concatenate(table_name) table not found in QlikView

concatenate(table_name) table not found

Thu, 14 Jun 2012 18:58:44 GMT

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

Re: concatenate(table_name) table not found

Thu, 14 Jun 2012 19:02:37 GMT

witch table is not found? tempTable?

Re: concatenate(table_name) table not found

Thu, 14 Jun 2012 19:03:18 GMT

table not found

Concatenate(Order)

Re: concatenate(table_name) table not found

Thu, 14 Jun 2012 19:07:58 GMT

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

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

Eva

Re: concatenate(table_name) table not found

Thu, 14 Jun 2012 19:11:50 GMT

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

I'm stumped

Re: concatenate(table_name) table not found

Thu, 14 Jun 2012 19:15:35 GMT

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

Re: concatenate(table_name) table not found

Thu, 14 Jun 2012 19:27:26 GMT

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

.....

Re: concatenate(table_name) table not found

Thu, 14 Jun 2012 22:12:41 GMT

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.

Re: concatenate(table_name) table not found

Anonymous — Fri, 15 Jun 2012 06:17:20 GMT

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?

Re: concatenate(table_name) table not found

Fri, 15 Jun 2012 13:20:23 GMT

is it normal? you have got tempTable and TempTable

Re: concatenate(table_name) table not found

Fri, 15 Jun 2012 15:18:57 GMT

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.

Re: concatenate(table_name) table not found

Fri, 15 Jun 2012 15:24:16 GMT

could you check the post like "answered"?