This script function renames one or more existing QlikView internal table(s) after they have been loaded.
Either syntax: rename table or rename tables can be used.
Syntax:
Rename Table (using mapname | oldname to newname{ , oldname to newname })
Rename Tables (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 table names. |
| oldname | The old table name. |
| newname | The new table name. |
Limitations:
Two differently named tables cannot be renamed to having the same name. The script will run without errors, but the second table will not be renamed.
Example 1:
Tab1:
SELECT * from Trans;
Rename Table Tab1 to Xyz;
Example 2:
TabMap:
Mapping LOAD oldnames, newnames from tabnames.csv;
Rename Tables using TabMap;
