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:
| 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;
