topic Replace in Partial Reload in QlikView

Replace in Partial Reload

Fri, 03 Jan 2014 12:31:46 GMT

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

Fri, 03 Jan 2014 12:40:18 GMT

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

Fri, 03 Jan 2014 13:28:55 GMT

Thank you, Chris!

You are absolutely right.

Thank you!