Hi all
Below is the table that I have:
| c1_Code | c1_role | c1_name | r_code | r_role | r_Name |
| 1A | 45 | Joe Smith | 1A | 45 | Joey Smith |
| 1A | 45 | Joe Smith | 1A | 45 | Tony Turner |
| 1A | 45 | Joe Smith | 1A | 45 | Paul Dickson |
| B4 | 23 | Bob Marley | B4 | 23 | Bob Marleye |
| B4 | 23 | Bob Marley | B4 | 23 | Tony Turner |
I would like to perform a fuzzy match on the two name columns and then have a column added to the table with the % (the % below are random):
| c1_Code | c1_role | c1_name | r_code | r_role | r_Name | Fuzzy % |
| 1A | 45 | Joe Smith | 1A | 45 | Joey Smith | 99 |
| 1A | 45 | Joe Smith | 1A | 45 | Tony Turner | 60 |
| 1A | 45 | Joe Smith | 1A | 45 | Paul Dickson | 60 |
| B4 | 23 | Bob Marley | B4 | 23 | Bob Marleye | 99 |
| B4 | 23 | Bob Marley | B4 | 23 | Tony Turner | 60 |
The idea is that I can now filter out the rows which have less than 80% match score and identify the differences in the way the names are spelt
Many thanks!
