Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

Compare Two Fields (Spell Check)

Hi,

I have come across this issue where I need to do spell check between two name fields.

Database1: Member table - Field name: Member Name

Database2: Customer Table - Field name: Customer Name

Scenario1:

Member Name: John Doe

Customer Name: John Doee

Member Name: ANNA LIKED

Customer Name: ANA LIKED

In the above scenario both name are close match between Member name and Customer Name. I want to write a script which will compare such close association between names and flag it with 'YES' if matches and 'NO' if it do not.

Thanks,

H

0 Replies