Skip to main content

Rename table

ON THIS PAGE

Rename table

This script function renames one or more existing Qlik Sense 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:  

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 generate an error if you try to rename a table to the same name as an existing table.

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;