Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field name GINT which has following value TIm, TWA, TIC, now i want to convert that value name into bellow name .
field GINT is comming from AP TP table
TIm = TIm- ta IL CA
TWA= TIM- Wa AA
TIC= TA-Ws-CC
try this:
aux_change:
mapping
load * inline [
key,value
TIm,'TIm- ta IL CA'
TWA,'TIM- Wa AA'
TIC ,'TA-Ws-CC'
];
MAP Field GINT_New Using aux_change;
Table:
load
GINT,
GINT_New
FROM AP TP ;
Thanks, what i want to keep that old field with old name and and create new field with that new mapping name. so i can use both field in required place
You could use a IF instead a mapping,
If(GINT ='TIm','TIm- ta IL CA',If(GINT ='TWA','TIm- ta IL CA','TA-Ws-CC')) AS New_GINT
try this:
aux_change:
mapping
load * inline [
key,value
TIm,'TIm- ta IL CA'
TWA,'TIM- Wa AA'
TIC ,'TA-Ws-CC'
];
MAP Field GINT_New Using aux_change;
Table:
load
GINT,
GINT_New
FROM AP TP ;