Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
maybe this helps:
regards
Marco
Try Wildmatch
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*')
Maybe
Len(KeepChar('Maissy','Massy')) -> 5
Regards,
Antonio
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
Len(KeepChar(Field1,Field2)/Len(KeepChar(Left(Field1,Floor(Len(Field1)/2),Field2))
or other.
Regards,
Antonio
Hi Adami,
Soundex is a good function to consider in yuor case.
thanks,
Rajesh Vaswani