Replace in Partial Reload

[#1]

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

[#2 · Accepted solution]

Hi Kristina

It is I guess a behaviour of Qualify.

Because you first table was qualified   fields are named like 'ledgertrans.filedname1', ...

When you replace the filed are not qualified before load but after so there is a difference between names and a second table shows up.

You shoul better use alias instead of qualify  ( or tmp table, to load before replace, drop old one and rename new one.)

best regards

Chris

[#3]

Thank you, Chris!

You are absolutely right.

Thank you!