topic Unset alias in QlikView

Unset alias

lucarizziero — Tue, 18 May 2010 11:22:48 GMT

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

Tue, 18 May 2010 13:27:01 GMT

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 — Tue, 18 May 2010 16:10:53 GMT

How about another ALIAS :

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

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

Oleg