Rename table

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;

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?