Dear Alteryx Fam,
I am respectfully seeking assistance with regards to fuzzy matching of two datasets. Specifically, I have encountered challenges in matching names between the two datasets, resulting in an incorrect number of matched records (supposed to have 80 records).
I would greatly appreciate your support in resolving this matter. Attached herewith is my workflow for your reference.
Thank you in advance for your kind attention to this request.
Hello,
You have 144 matches but only 68 are unique
if you know the missing 12, you can work on that to see what the problems are
Hi @kevin0109 ,
I've attached the workflow with a few tweaks:
I've amended the field usage regarding Source and RecordID field. I've also changed the methodology to use the merge method with a source field created on the incoming streams to identify them as different sources.
I have changed the algorithms used in the Fuzzy match to focus on names and slightly tweaked the thresholds:
This allows the non-identical matches to be returned as well, and their corresponding matching scores to records not in their source.
I've attached the workflow for you.
I hope this helps,
M.