sorry, I misspelled, in the code I wrote correct
RENAME FIELD FieldDate TO SalesDate;
I tried to change the name of the field in TestField and it work.
RENAME FIELD FieldDate TO TestField;
Luca Jonathan Panetta
Can you post some sample code or specify your scenario step by step so we can reproduce it?
I'm trying to replicate it, renaming after joining, and it seems it's working.
EDIT: I see what you say now. I haven't found anything in the Reference Manual, but it makes sense to me because the associative logic and the way QlikView has to associate one table to another. As it is always by means of the name of the field, I wouldn't be surprised I QlikView didn't allow to change any field to a name that is already associating two tables, after the model has been loaded. In the end, you can always change the name in the LOAD part if you want to create relations between tables.
It doesn't allow you to do the opposite either. QlikView doesn't rename a relation field (key field) to any other name. My guess is that if you already wanted to do that, you could have done it in the LOAD process, renaming with "AS" to build/separate tables because of their fieldnames.
And it doesn't work in version 9 either (SR6 Build 7646.9), which in turn adds sense to the above.
Basically, QlikView allows renaming of fields to a new one that doesn't exist in your data model, but it doesn't to an already existing name. Or rather, it doesn't allow you to create links between tables using RENAME FIELD.
Does any of this makes sense to you? Did you try in previous versions with different results?
Message was edited by: Miguel Angel Baeyens