Skip to main content Skip to complementary content

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;

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com