topic Cannot Rename field in QlikView

Cannot Rename field

Tue, 20 Oct 2009 21:51:42 GMT

I tried to rename a field, because I want it to be associated with an existing field. However this does not work. I can find no restrictions in the reference manual and I don't get an error message either. See code below. Is this a bug or a undocumented feature. : ) (The renaming works when the load sequence is reversed.) Other workarounds are welcome.

SET ErrorMode=1;

Qualify *;

Unqualify 'SID*';

LOAD KEY_SIS_C094,

SID_SIS_RSSTE

FROM

(qvd);

LOAD [SID2_SSS_PLANT_/BIC/SSS_PLANT],

SID_SSS_PLANT,

CHCKFL,

DATAFL,

INCFL

FROM

(qvd);

rename field 'SID_SSS_PLANT' to 'SID_SIS_RSSTE';

Cannot Rename field

Tue, 20 Oct 2009 22:01:41 GMT

Try
LOAD [SID2_SSS_PLANT_/BIC/SSS_PLANT],
SID_SSS_PLANT As SID_SIS_RSSTE,
CHCKFL,
DATAFL,
INCFL
FROM (qvd);

and it should work
Talha

Cannot Rename field

Tue, 20 Oct 2009 22:02:38 GMT

Couldn't you just use an alias?

LOAD...
SID_SSS_PLANT As SID_SIS_RSSTE, ...

Cannot Rename field

Tue, 20 Oct 2009 23:13:15 GMT

Aliassing is not an option because the code from this post is not the actual code. It is just for illiustrating the issue. The original code is generic and based on metadata so i don't know the column names beforehand and my best solution is to use "select * from". I am raising this issue so Qlikview can be improved. My question still remains: is this a (known) bug, or an ommision in the documentation. And if so where can I report this issue ?

Cannot Rename field

biester — Wed, 21 Oct 2009 00:57:10 GMT

I tried around a little with the thing, and after that I actually think the (intended) behaviour is due to the fact that you are renaming keys.

To put it very simple (as said it's only a very simple way of how I could imagine that things could be, but it would explain the behaviour): after the second load there is no join between the tables and the joining has been done, so you can't rename to a keyfield which would alter the joining; perhaps sort of the logic or mechanism that does not allow you to alter the joining by qualifying and unqualifying AFTER having loaded data. I would report the issue to support and ask for an explanation.

Again, just a simple minded thought. Perhaps some of the specialists here who have a deeper insight could explain.

Rgds,
Joachim

Cannot Rename field

Wed, 21 Oct 2009 02:54:16 GMT

That sounds like a plausible explanation. Still it would have been nice if a "can't rename field to an existing name" error would have been raised or if it would have been documented in the reference guide. A forward to support sounds like a good idea.

Cannot Rename field

Thu, 19 May 2011 09:16:26 GMT

Exists some conclustion to this issue?

Cannot Rename field

ToniKautto — Thu, 19 May 2011 09:46:55 GMT

If this is still an issue with QV10 SR2, please report it as a possible bug to QlikView Support.

http://qlik.com/Support

Cannot Rename field

Thu, 19 May 2011 09:52:37 GMT

Actually it's still issue in QV10 SR2. Problem is when I have Linked Object List box with field e.g. CalendarYear and I rename it in script to e.g. BookingYear, than the script just crash without any script error.

Cannot Rename field

ToniKautto — Thu, 19 May 2011 11:25:55 GMT

You could report it to support for a more detailed evaluation of the crash.

http://qlik.com/Support

Cannot Rename field

pljsoftware — Tue, 07 Jun 2011 15:57:11 GMT

Hi guys!

I have the same problem in QV10 SR2 build 8935.7.

I have verified that the problem occurs when I try to rename a field that join with other field e.g. MasterCalendar with field Date that I try to rename in SalesDate and a table Sales with field SalesDate.

I think that is a BUG.

Regards

Luca Jonathan Panetta

PLJ Software

Cannot Rename field

Tue, 07 Jun 2011 16:14:22 GMT

This renaming problems occured to me when I have the renamed field in layout as a linked object accross separate tabs.

I actually unlinked all objects and problem disappears.

Additionally you might get problem that the renamed field isn't renamed in expression in some objects in Container object.

I used the dummy workaround that I keep the original object minimized somewhere hidden, so the link between original and linked object in Container is kept and the renamed field is correctly changed in expression.