Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue with applymap function

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?

1 Solution

Accepted Solutions
sunny_talwar

May be this

maptable:

Mapping

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

[Revised Resolution code]

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

View solution in original post

2 Replies
sunny_talwar

May be this

maptable:

Mapping

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

[Revised Resolution code]

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

Anonymous
Not applicable
Author

thanks..it worked