Discussion board where members can get started with Qlik Sense.
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
try this:aux_change:mappingload * inline [key,valueTIm,'TIm- ta IL CA'TWA,'TIM- Wa AA'TIC ,'TA-Ws-CC'];
MAP Field GINT_New Using aux_change;Table:loadGINT,GINT_NewFROM AP TP ;
View solution in original post
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