topic Re: Strange error renaming a field in QlikView

Strange error renaming a field

datanibbler — Fri, 15 Jun 2018 09:07:49 GMT

Hi,

I have changed the contents of the field >> %KEY << in a table, named the new >> %KEY_unique <<.

I can then drop the field from only this table - because several other tables, all of which are going to be used to create a LinkTable, also contain a field >> %KEY << - but then, how can I rename that field >> %KEY_unique TO %KEY << just for this one table?

I guess that is the reason I am always getting a message "New field name already exists", even when, after dropping the existing field, there is no field >> %KEY << in this table - but there is in other tables ...

Thanks a lot!

Best regards,

DataNibbler

Re: Strange error renaming a field

marcus_sommer — Fri, 15 Jun 2018 09:17:31 GMT

If a field get a new name it is just a small change within the meta-data but it couldn't work if this field already exists because a field contained only distinct values and they are connected through a pointer to the datatables - and both parts the symboltable behind the fieldvalues and also the pointer needs to be recreated/refreshed if there come new/further values - and this needs to be done with a load-statement and therefore the rename-statement reacts with an error-message.

- Marcus

Re: Strange error renaming a field

datanibbler — Fri, 15 Jun 2018 09:27:20 GMT

Thanks Marcus!

I'm doing it another way and that seems to be working: I just don't create that field in that table before, so I don't have to change it and there is no need to DROP and RENAME.

Best regards,

DataNibbler