Please Help - Fuzzy Logic to create match score and rejoin to original data set

[Akdashboard]

Hello wonderful community.

I am trying to use Fuzzy Logic to create the match score for 2 columns in my data set (Field 1 and Field 2 below) and then attach the match score to the original data set. I thought I could do this with a join or a replace, but I am ending up with far fewer records than I am expecting (1115 to 14, for example). In Theory, all records should join with a score, I think.

Field 1	Field 2	Other data 1	Other data 2	Other data 3
ABC	CBA	-	-	-
DEF	1FED	-	-	-
GHI	78G	-	-	-
JKL	JK1	-	-	-
123	984	-	-	-
456	652	-	-	-
789	789	-	-	-

I would think the process would simply be to use the select to get Field 1 and Field 2, use union to stack on top of each other to get the format ready for Fuzzy Logic, run fuzzy logic, join back to original data set.

[atcodedog05]

Hi @Akdashboard 

Use find and replace tool to do vlookup instead this doesn't filter rows.

[atcodedog05]

Hi @Akdashboard 

It could be possible names are not matching hence left. Can share your workflow we can take a look into it.