Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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
....
;
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
....
;