Fuzzy Lookup in Qliksense

kvr9 — Thu, 07 Jul 2022 13:47:16 GMT

Hi ,

We have a customer data and customer name is stored as below format, I would like to use fuzzy logic and derive a single line for that customer,

Input data

Thomas Craig(Premium)

Thomas Craig

T.Craig

Required output is Thomas Craig.

Re: Fuzzy Lookup in Qliksense

rwunderlich — Thu, 07 Jul 2022 16:56:35 GMT

One solution is to build a mapping table of the exceptions mapped to the final name. You have to maintain this by hand, but you only have to include the exceptions, or potential exceptions. For example:

CompanyMap:
MAPPING
LOAD * INLINE [
from, to
I.B.M, IBM
Intl Bus Mach, IBM
Msoft, Microsoft
MS, Microsoft
]
;

MAP Company USING CompanyMap;

Companies:
LOAD Company
INLINE [
Company
IBM
I.B.M
Microsoft
Msoft
MS
ms
Energy Specialists
]
;

Another option is to use MapSubstring to look for partial names, but that doesn't cover all situations well. e.g T.Craig.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

topic Fuzzy Lookup in Qliksense in App Development

Fuzzy Lookup in Qliksense

Re: Fuzzy Lookup in Qliksense