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.
Hi @Akdashboard
It could be possible names are not matching hence left. Can share your workflow we can take a look into it.