topic Re: Changing Field Names in script using translation table in QlikView https://community.qlik.com/t5/QlikView/Changing-Field-Names-in-script-using-translation-table/m-p/460862#M172055 <HTML><HEAD></HEAD><BODY><P>Use the rename statement. See more on <A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields">http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields</A></P><P></P><P>HIC</P></BODY></HTML> Tue, 11 Jun 2013 16:24:23 GMT hic 2013-06-11T16:24:23Z Changing Field Names in script using translation table https://community.qlik.com/t5/QlikView/Changing-Field-Names-in-script-using-translation-table/m-p/460861#M172054 <HTML><HEAD></HEAD><BODY><P>Hi I need some quick help.</P><P></P><P>I have a translation table with Fieldnames and its new fieldNames:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="201"><TBODY><TR><TD class="xl63" height="20" width="96">OldFieldName</TD><TD class="xl63" style="border-left: none;" width="105">NewFieldName</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">a-AA</TD><TD class="xl63" style="border-top: none; border-left: none;">a1-AA</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">b-AA</TD><TD class="xl63" style="border-top: none; border-left: none;">b1-AA</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">c-AA</TD><TD class="xl63" style="border-top: none; border-left: none;">c1-AA</TD></TR></TBODY></TABLE><P></P><P>i have my data table :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="111"><TBODY><TR><TD class="xl65" height="20" width="37">a-AA</TD><TD class="xl65" style="border-left: none;" width="38">b-AA</TD><TD class="xl65" style="border-left: none;" width="36">c-AA</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;"><P>3</P></TD></TR></TBODY></TABLE><P>Using the translation table i want to rename the field names a-AA,b-AA,c-AA so my table looks like below:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="132"><TBODY><TR><TD class="xl65" height="20" width="44">a1-AA</TD><TD class="xl65" style="border-left: none;" width="45">b1-AA</TD><TD class="xl65" style="border-left: none;" width="43">c1-AA</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD></TR></TBODY></TABLE><P></P><P>Is it so simple that im missing the basics here .. i dont want to be using the Aliases in the script. i just want to use my translation table .</P><P></P><P>please help</P></BODY></HTML> Tue, 11 Jun 2013 13:56:07 GMT https://community.qlik.com/t5/QlikView/Changing-Field-Names-in-script-using-translation-table/m-p/460861#M172054 nam 2013-06-11T13:56:07Z Re: Changing Field Names in script using translation table https://community.qlik.com/t5/QlikView/Changing-Field-Names-in-script-using-translation-table/m-p/460862#M172055 <HTML><HEAD></HEAD><BODY><P>Use the rename statement. See more on <A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields">http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields</A></P><P></P><P>HIC</P></BODY></HTML> Tue, 11 Jun 2013 16:24:23 GMT https://community.qlik.com/t5/QlikView/Changing-Field-Names-in-script-using-translation-table/m-p/460862#M172055 hic 2013-06-11T16:24:23Z