Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lucarizziero
Partner - Contributor III
Partner - Contributor III

Unset alias

Hi,

Is there a way to unset a previous alias setting ?

For ex.:

ALIAS a AS alpha, b as beta;

LOAD a, b FROM ... ;

--> table result with fields alpha and beta

[unset alias]

LOAD a, b FROM ... ;

--> table result with fields a and b

Thanks

2 Replies
Not applicable

Hi

No unalias command is available, you either have to use AS in the first load or place the second load before the ALIAS command

LOAD a as alpha, b as beta ...

But I guess you created for us an easy example for your much more complicated loads ...

Juerg

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

How about another ALIAS :

ALIAS a as a, b as b, ... :

Haven't tried it, but I think it should work...

Oleg