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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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

Ask me about Qlik Sense Expert Class!