Changing Field Names in script using translation table

[nam]

Hi I need some quick help.

I have a translation table with Fieldnames and its new fieldNames:

OldFieldName	NewFieldName
a-AA	a1-AA
b-AA	b1-AA
c-AA	c1-AA

i have my data table :

a-AA	b-AA	c-AA
1	2	3
2	3	2
3	4	3

Using the translation table i want to rename the field names a-AA,b-AA,c-AA so my table looks like below:

a1-AA	b1-AA	c1-AA
1	2	3
2	3	2
3	4	3

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 .

please help

[hic · Accepted solution]

Use the rename statement. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields

HIC