Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

hkg_qlik
Contributor II

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

Community Browser