drop table cause trouble

[#1]

HI

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

[Anonymous]

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

[#3]

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 *

[#4]

Thank you