topic Re: Compare two words in QlikView

Compare two words

Fri, 12 Jun 2015 11:03:29 GMT

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!

Re: Compare two words

Anonymous — Fri, 12 Jun 2015 11:14:05 GMT

Try Wildmatch

Re: Compare two words

maleksafa — Fri, 12 Jun 2015 11:22:33 GMT

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*')

Re: Compare two words

antoniotiman — Fri, 12 Jun 2015 11:30:12 GMT

Maybe

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

Regards,

Antonio

Re: Compare two words

Fri, 12 Jun 2015 11:59:42 GMT

i always use :

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

Re: Compare two words

Fri, 12 Jun 2015 12:29:26 GMT

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

Re: Compare two words

Fri, 12 Jun 2015 12:34:38 GMT

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

Re: Compare two words

antoniotiman — Fri, 12 Jun 2015 12:47:44 GMT

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

MarcoWedel — Fri, 12 Jun 2015 14:28:20 GMT

Hi,

maybe this helps:

Fuzzy Matching/Joining

Levenshtein Algorithm

regards

Marco

Re: Compare two words

rajeshvaswani77 — Fri, 12 Jun 2015 14:34:01 GMT

Hi Adami,

Soundex is a good function to consider in yuor case.

thanks,

Rajesh Vaswani

Re: Compare two words

Fri, 12 Jun 2015 15:30:49 GMT

This Levenshtein looks like a little simple, but anyway it worked, it's better than nothing, thank you!