Skip to main content
Rename field

ON THIS PAGE

Rename field

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

Information noteIt 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:  

Rename field 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;

Join the Analytics Modernization Program

Modernize by leveraging your QlikView investment to begin using Qlik Sense on the Cloud.

Want to know more?
Remove banner from view