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?
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*')
Thank you , in fait I want to do the comparison for a total colonne, not just a word like 'Mas*', but also others.
Len(KeepChar('Maissy','Massy')) -> 5
Interesting, I tested it, the disavantage is it will give also a good point for this cas: Len(KeepChar('Maissy','saisMy')) -> 6
You can add expressions like
i always use :
if(match('Masy','Massy') =1,your expression )
maybe this helps:
This Levenshtein looks like a little simple, but anyway it worked, it's better than nothing, thank you!
Soundex is a good function to consider in yuor case.
Retrieving data ...