Alias

The alias statement is used for setting an alias according to which a field will be renamed whenever it occurs in the script that follows.

Syntax:

alias fieldname as aliasname {,fieldname as aliasname}

Arguments:

Argument	Description
fieldname	The name of the field in your source data
aliasname	An alias name you want to use instead

Example	Result
Alias ID_N as NameID;
Alias A as Name, B as Number, C as Date;	The name changes defined through this statement are used on all subsequent SELECT and LOAD statements. A new alias can be defined for a field name by a new alias statement at any subsequent position in the script.

Learn more

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!