Fuzzy Match 2 Columns with score
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Lauritsjust
7 - Meteor
‎02-07-2022
02:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All
I am using the solution provided in Comparing Records between two columns for similarity
However, the solution is not quite what I am looking for. The solution provided only looks up the pairs provided in Field1 and Field2, where i would like the solution to find the "highest" match from field 1 and field 2.
Input:
Output:
Desired output:
I would like the result to show me that (Field1:8) and (Field2:5) are almost the same, and the names can thus be corrected in my full dataset.
I also need to filter for unique values.
Any ideas?
Labels:
- Labels:
- Fuzzy Match
0 REPLIES 0
