The 'Rename Field' Regular Statement

This article will cover the syntax of the ‘Rename Field’ regular script statement.

This statement allows specified fields to be renamed.

Statement syntax


Rename Field  | Fields using mapname | oldname to newname{ , oldname to newname }

Field \| Fields	Single or multiple fields can be specified with the rename statement.
Using Mapname	The fields can be renamed using a previously created map.
Oldname to Newname	If not using a map, fields and their new names can be specified in a comma separated list.

Example

An ‘id’ field is renamed for clarity after a table containing customer data is loaded.

Copy code


CUSTOMERS:
LOAD
    id,
    firstName,
    lastName,
    email,
    dob
FROM [lib://Public:DataFiles/customers.xlsx]
(ooxml, embedded labels, table is Sheet1);
Rename field id to customerId;