Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Compare two words

Hello,

I want to comparer the words for exemple: Masy and  Massy, or Massy and Maissy.

In SQL, we have a function UTL_MATCH.edit_distance to give a level that represent the approaching of two word.

How can we do that in Qlikview?

thank you!

1 Solution

Accepted Solutions

Re: Compare two words

Hi,

maybe this helps:

Fuzzy Matching/Joining

Levenshtein Algorithm

regards

Marco

10 Replies
jebamalai
Valued Contributor

Re: Compare two words

Try Wildmatch

maleksafa
Valued Contributor

Re: Compare two words

the wildmatch is a little bit similar, you need to consider as the like operator in sql.

SQL: words like 'Mas%'

Qlik: wildmatch( Words, 'Mas*')

antoniotiman
Honored Contributor III

Re: Compare two words

Maybe

Len(KeepChar('Maissy','Massy'))   -> 5

Regards,

Antonio

Not applicable

Re: Compare two words

i always use :

if(match('Masy','Massy') =1,your expression )

Not applicable

Re: Compare two words

Interesting, I tested it, the disavantage is it will give also a good point  for this cas: Len(KeepChar('Maissy','saisMy'))   -> 6

Not applicable

Re: Compare two words

Thank you , in fait I want to do the comparison for a total colonne, not just a word like 'Mas*', but also others.

antoniotiman
Honored Contributor III

Re: Compare two words

You can add   expressions like

Len(KeepChar(Field1,Field2)/Len(KeepChar(Left(Field1,Floor(Len(Field1)/2),Field2))

or other.

Regards,

Antonio

Re: Compare two words

Hi,

maybe this helps:

Fuzzy Matching/Joining

Levenshtein Algorithm

regards

Marco

rajeshvaswani77
Valued Contributor III

Re: Compare two words

Hi Adami,

Soundex is a good function to consider in yuor case.

thanks,

Rajesh Vaswani

Community Browser