Skip to main content Skip to complementary content

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:  

Alias arguments
Argument Description
fieldname

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

Examples and results:  

Examples and results
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

 

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 – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com