Compare two words

[#1]

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!

[Anonymous]

Try Wildmatch

[maleksafa]

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]

Maybe

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

Regards,

Antonio

[#5]

i always use :

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

[#6]

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

[#7]

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

[antoniotiman]

You can add   expressions like

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

or other.

Regards,

Antonio

[MarcoWedel · Accepted solution]

Hi,

maybe this helps:

Fuzzy Matching/Joining

Levenshtein Algorithm

regards

Marco

[rajeshvaswani77]

Hi Adami,

Soundex is a good function to consider in yuor case.

thanks,

Rajesh Vaswani