giving alias to columns

[ali_hijazi]

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:

TYP	Type de pièce
NUM	Numéro de pièce
CPY	Société
FCY	Site
JOU	Journal
FIY	Exercice
PER	Période

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 · Accepted solution]

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]

thank you

the RENAME Fields using Map is new to me !!