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;

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?