topic Re: Issue with applymap function in QlikView

Issue with applymap function

Anonymous — Wed, 08 Mar 2017 12:15:06 GMT

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?

Re: Issue with applymap function

sunny_talwar — Wed, 08 Mar 2017 12:19:47 GMT

May be this

maptable:

Mapping

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

[Revised Resolution code]

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

Re: Issue with applymap function

Anonymous — Wed, 08 Mar 2017 12:44:53 GMT

thanks..it worked