Hello,
I was wondering what tool I should use for obtaining similarity between two fields. I know that you can use an IF conditional, but this will only put out T or F if it is an exact match. I want to be able to compare the first record from one column with the first record from another column and see what the resulting match percentage is.
Example:
| ABC | ABC, 123 | |
| DEF | DEF | |
| GHI | GIH | |
Result:
| ABC | ABC, 123 | 80% |
| DEF | DEF | 100% |
| GHI | GIH | 90% |
I know that Fuzzy Match allows you to compare records from one column. I was wondering if there was something similar with a different tool, or if you can achieve this with Fuzzy Match.
