Issue with applymap function

[Anonymous]

I am using applymap function to group a list resolution code value with a revised list of resolution code values

maptable:

mapping

load

[Resolution code],

[Revised Resolution code]

applymap('maptable',[Resolution code],null()) as New_Resolution_code

All values are getting correctly mapped except for the one pasted below..

Resolution code                                                                                                                           Revised Resolution code

Other.Product.Issues originated due to Incorrect use of product, advise given                          Customer Enquiry

i believe the mapping fails due to the delimiter ',' that appears in the resolution code and that is causing confusion while mapping. Can anybody please suggest a workaround?

[sunny_talwar · Accepted solution]

May be this

maptable:

Mapping

LOAD PurgeChar([Resolution code], ',')

[Revised Resolution code]

ApplyMap('maptable', PurgeChar([Resolution code], ','), Null()) as New_Resolution_code

[Anonymous]

thanks..it worked