Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this
maptable:
Mapping
LOAD PurgeChar([Resolution code], ',')
[Revised Resolution code]
ApplyMap('maptable', PurgeChar([Resolution code], ','), Null()) as New_Resolution_code
May be this
maptable:
Mapping
LOAD PurgeChar([Resolution code], ',')
[Revised Resolution code]
ApplyMap('maptable', PurgeChar([Resolution code], ','), Null()) as New_Resolution_code
thanks..it worked