What is the difference between "alias" and "as" in... - Qlik Community

oussema_laribi · ‎2018-03-21

Hello,

Can anyone explain to me

What is the difference between "alias" and "as" in QlikView with example.

Thnanks for advance.

olivierrobin · ‎2018-03-21

hello

as is used in INE load statement to rename the fiels in that statement

alias is used to rename a field in all statements following it

Chanty4u · ‎2018-03-21

Hi

please read from help file with example

pavandbs · ‎2018-03-29

Hi,

To explain in detail , alias you can use to rename a field in whole script. Where 'as' can use for each field.

From the following example

1. From test table CountryID will be shown as CountryName after reload.

2. In resident load you can not use CountryID as it already renamed to CountryCode.

3. You can again rename CountryCode to another name using 'as' like Country# I used.

Hope it answers your question.

What is the difference between "alias" and "as" in QlikView?