Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Replace in Partial Reload

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

2 Replies
Not applicable

Re: Replace in Partial Reload

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

Not applicable

Re: Replace in Partial Reload

Thank you, Chris!

You are absolutely right.

Thank you!

Community Browser