- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What Piece of code do I use to change similar names
I have used the above piece of code to change all caps to lower case and it works fine.
=if(upper(ClaimStatusDescription)='SERVICE','Service',
What piece of code can I use to change "Servicing" to "Service"? and "Service Delays" to Service
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
if(wildmatch(ClaimStatusDescription,'servic*'),'Service',ClaimStatusDescription)
won't care about upper or lower case
or, if you whan to be more specific
if(wildmatch(ClaimStatusDescription,'Servicing','Service Delays'),'Service',ClaimStatusDescription)
hope it helps
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
if(wildmatch(ClaimStatusDescription,'servic*'),'Service',ClaimStatusDescription)
won't care about upper or lower case
or, if you whan to be more specific
if(wildmatch(ClaimStatusDescription,'Servicing','Service Delays'),'Service',ClaimStatusDescription)
hope it helps
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
You can use different approaches, but one of them could be to use the Levenshtein distance between strings. In case of Servicing vs Service it's 3, that is a 33% of the base string length:
More info here: https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions...
JG