topic Re: giving alias to columns in QlikView

giving alias to columns

ali_hijazi — Wed, 26 Sep 2018 10:41:45 GMT

Hello

got a table whose fields are the following:

TYP

NUM

CPY

FCY

JOU

FIY

PER

and there is another table that holds the aliases for each column above as follows:

is there a way to give aliases in the load statement without hardcoding; something like
load

TYP as applymap('mappng_table',name) ....

kindly advise

Frank_Hartmann — Wed, 26 Sep 2018 11:20:40 GMT

Something like this should work:

Map:

Mapping LOAD * INLINE [

TYP, Type de pièce

NUM, Numéro de pièce

CPY, Société

FCY, Site

JOU, Journal

FIY, Exercice

PER, Période

];

tmp:

Load * Inline [

TYP, NUM, CPY, FCY, JOU, FIY, PER

]; RENAME Fields using Map;

hope this helps

ali_hijazi — Wed, 26 Sep 2018 11:59:04 GMT

thank you

the RENAME Fields using Map is new to me !!