
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Compare two words
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!
- Tags:
- qlikview_scripting
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
maybe this helps:
regards
Marco

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try Wildmatch


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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*')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe
Len(KeepChar('Maissy','Massy')) -> 5
Regards,
Antonio

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i always use :
if(match('Masy','Massy') =1,your expression )

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Interesting, I tested it, the disavantage is it will give also a good point for this cas: Len(KeepChar('Maissy','saisMy')) -> 6

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you , in fait I want to do the comparison for a total colonne, not just a word like 'Mas*', but also others.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can add expressions like
Len(KeepChar(Field1,Field2)/Len(KeepChar(Left(Field1,Floor(Len(Field1)/2),Field2))
or other.
Regards,
Antonio


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Adami,
Soundex is a good function to consider in yuor case.
thanks,
Rajesh Vaswani

- « Previous Replies
-
- 1
- 2
- Next Replies »