Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
maybe this helps:
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*')
Len(KeepChar('Maissy','Massy')) -> 5
i always use :
if(match('Masy','Massy') =1,your expression )
Interesting, I tested it, the disavantage is it will give also a good point for this cas: Len(KeepChar('Maissy','saisMy')) -> 6
Thank you , in fait I want to do the comparison for a total colonne, not just a word like 'Mas*', but also others.
You can add expressions like
Soundex is a good function to consider in yuor case.