Table Not Found

[etrotter]

Hi,

I am doing a resident load, but for some reason it's not recognizing the "Workday" table it just keeps saying table not found. There is  a table called Personal earlier in the script that I'm resident loading from. Please let me know if you can help:

Workday:

Load DISTINCT

[Encore.W_CODE],

Worker_ID,

[GLS.W_CODE],

Address,

City,

State,

Zip_Code,

First_Name,

Last_Name

Resident Personal;

Drop Table Personal;

Left Join (Workday)

Load

Worker_ID,

Shift_Pay

Resident Compensation;

[petter · Accepted solution]

If you load a table from a resident table and you keep all the fields the same  it will not create a new table but rather add all the records to the first table.

You can avoid that by using a NOCONCATE prefix like this:

Workday:

Noconcatenate LOAD DISTINCT

....

;