Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a field = GP_TYPE_ from Mapping :-
ApplyMap('MapGroupType',@43:48T,@307:314T) AS GP_TYPE_,
Which have value label from 1 to 16
i Need to recode
1 to G1
2 to G2
3 to G3
4 to G4
...
...
16 to G16
Just put a G in front.
Hope some one can share with me.
Paul Yeo
You can try:
'G'&ApplyMap('MapGroupType',@43:48T,@307:314T) AS GP_TYPE_,
Enclosed my QVW
You can try:
'G'&ApplyMap('MapGroupType',@43:48T,@307:314T) AS GP_TYPE_,
Hi Sir
Thank you very much for your sharing. it is what i want.
I also want to know how to make use of partial reload for recode , i have post below question :-
Hope you can share with me why not working ?
Paul