topic rename field in QlikView https://community.qlik.com/t5/QlikView/rename-field/m-p/681553#M247094 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I got a table that contains fields two of which are called Defect_id and Correction_defect_id</P><P></P><P>i have the following script :</P><P>DROP Field DEFECT_ID FROM TEMP2_QC_REG;</P><P>&nbsp; RENAME Field CORRECTION_DEFECT_ID TO DEFECT_ID;</P><P></P><P>CORRETION_DEFECT_ID is only available in the table temp2_qc_reg</P><P>this script runs successfully on the QV client but when I run the task on the server I get the error on the second line above saying New field name already exists!</P><P></P><P>how the same script works fine on the client not fails on the server ?</P><P></P><P>Please advise</P></BODY></HTML> Wed, 24 Sep 2014 11:23:54 GMT ali_hijazi 2014-09-24T11:23:54Z rename field https://community.qlik.com/t5/QlikView/rename-field/m-p/681553#M247094 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I got a table that contains fields two of which are called Defect_id and Correction_defect_id</P><P></P><P>i have the following script :</P><P>DROP Field DEFECT_ID FROM TEMP2_QC_REG;</P><P>&nbsp; RENAME Field CORRECTION_DEFECT_ID TO DEFECT_ID;</P><P></P><P>CORRETION_DEFECT_ID is only available in the table temp2_qc_reg</P><P>this script runs successfully on the QV client but when I run the task on the server I get the error on the second line above saying New field name already exists!</P><P></P><P>how the same script works fine on the client not fails on the server ?</P><P></P><P>Please advise</P></BODY></HTML> Wed, 24 Sep 2014 11:23:54 GMT https://community.qlik.com/t5/QlikView/rename-field/m-p/681553#M247094 ali_hijazi 2014-09-24T11:23:54Z