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 |
Solved! Go to Solution.
The Fuzzy Match tool 😊Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung
Check out my response to your other thread:
Fuzzy Match Workflow - Alteryx Community
This added context helps - I agree a Find Replace is better in this situation.