Discussion Board for collaboration on QlikView Scripting.
I have partial reload of 1 table with the following script:
UNQUALIFY [Calendar*], [CurrencyRate*], [Stoma];
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.
Go to Solution.
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.)
Thank you, Chris!
You are absolutely right.