Hello,
I have one table and in that table are two name fields, how do I find the similarity/confidence level for those two names? I tried using the fuzzy lookup but that gives me the similarity/confidence of the best match in the same table but not what it is for that row. Here's the output I'm trying to achieve.
Original Table
Row Name1 Name2
1 John Joe
2 John John
3 Tim Timothy
Output Table
Row Name1 Name2 SimilarityBetweenName1and2 ConfidenceBetweenName1and2
1 John Joe .50 .25
2 John John 1 1
3 Tim Timothy .90 .80
Thanks in advance.