topic drop table cause trouble in QlikView

drop table cause trouble

Thu, 08 Nov 2012 13:04:35 GMT

i doing the following:

TABLE1:

load distinct

FactKey_Failure,

Customer_Number_Failure as Customer_Number,

Failure_date as Date_Calander

RESIDENT Failure1;

join

load distinct

FactKey_Jam,

Customer_Number_Paper_Jams as Customer_Number,

date_Jame as Date_Calander

RESIDENT Paper1;

LINK_TABLE :

load *

RESIDENT TABLE1;

drop table TABLE1;

For some reason I can not find TABLE1 or LINK_TABLE why ??

But If I dont use drop table everything ok

Re: drop table cause trouble

Anonymous — Thu, 08 Nov 2012 13:13:28 GMT

Because your link_table was never created - it was auto-concatenated to the table1.

you can add noconcatenate before loading link table to fix it

Re: drop table cause trouble

Thu, 08 Nov 2012 13:14:24 GMT

The tables probalbly look to much like each other and he auto concatenates them. If you put a NoConcatenate between the 2 tables your drop table statement wil work.

Like this:

load distinct

FactKey_Jam,

Customer_Number_Paper_Jams as Customer_Number,

date_Jame as Date_Calander

RESIDENT Paper1;

NoConcatenate

LINK_TABLE :

load *

Re: drop table cause trouble

Thu, 08 Nov 2012 13:20:08 GMT

Thank you