1 Reply Latest reply: Apr 5, 2018 9:41 AM by Petter Skjolden RSS

    Table Not Found

    Erica Trotter

      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;

        • Re: Table Not Found
          Petter Skjolden

          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

          ....

           

          ;