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:

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

Examples with results

For the examples in the table below, the defined field name changes will be applied to references of the original field name 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.

The field is also referenced with the alias name in the data model and app content.

Examples and results
Example	Result
Alias ID_N as NameID;	Field ID_N is renamed to NameID.
Alias A as Name, B as Number, C as Date;	Fields A, B, and C are renamed to Name, Number, and Date respectively.

Overview

Open the Data load editor and add the load script below to a new section.

Load script

alias [A] as [AAA];
						T1:
						Load 'string 1' as A autogenerate 1;
						T2:
						Load 'string 2' as B autogenerate 1;
						T3:
					Load 'string 3' as A autogenerate 1;

Results

Load the data and open a sheet. Create a new table and add this field as a dimension:

Results table
AAA
string 1
string 3

Learn more

Did this page help you?

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

Leave your feedback here

Alias

Examples with results

Learn more

Did this page help you?

Join the Analytics Modernization Program