Rename field

This script function renames one or more existing QlikView field(s) after they have been loaded.

Note: It is not recommended to use the same name for a field and a variable in QlikView.

Either syntax: rename field or rename fields can be used.

Syntax:  

Rename Field (using mapname | oldname to newname{ , oldname to newname })

Rename Fields (using mapname | oldname to newname{ , oldname to newname })

Arguments:  

Argument Description
mapname The name of a previously loaded mapping table containing one or more pairs of old and new field names.
oldname The old field name.
newname The new field name.

Limitations:  

Two differently named fields cannot be renamed to having the same name. The script will run without errors, but the second field will not be renamed.

Example 1:  

Rename Field XAZ0007 to Sales;

Example 2:  

FieldMap:

Mapping SQL SELECT oldnames, newnames from datadictionary;

Rename Fields using FieldMap;