Fuzzy Match Names

[nmotiani]

I am trying to match org names to another list of org names.

Since the names from both datasets don't exactly match, which is why I cant use the join tool. How do I figure out the close matches? Can someone help me build a short workflow?

example:

Data Set 1

Organization	ID
Apple	1
Orange	2
Banana	3
Kiwi	4

Data Set 2

Organization	ID
Apple Association	A
Orange Company	B
Banana and brothers	C
Kiwi and Co.	D

[alexnajm]

The Fuzzy Match tool 😊Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung 

[jrlindem · Accepted solution]

 Check out my response to your other thread:

Fuzzy Match Workflow - Alteryx Community

[alexnajm · Accepted solution]

This added context helps - I agree a Find Replace is better in this situation.