2 Replies Latest reply: Jan 3, 2014 8:28 AM by Kristina Vodich RSS

    Replace in Partial Reload

      Dear all,

       

      I have partial reload of 1 table with the following script:

       

      QUALIFY *;

      UNQUALIFY [Calendar*], [CurrencyRate*], [Stoma];

      [LedgerTrans]:

      REPLACE LOAD

        OFFSETACCOUNTTYPE & '-' & ACCOUNTTYPE_TXT AS TypeOfAccount,

        OFFSETACCOUNT & '-' & ACCOUNTTYPE AS TypeOfCount,

           ...

      ;

      SQL EXEC sp;

       

      But after partial reload I don't get my table LedgerTrans replaced, but duplicated with the new table LedgerTrans-1

       

      Is it because of using QUALIFY *; ?

       

      Thanks in advance.

      Regards,

      Kristina