Hello, I am a newbie with Alteryx and I was wondering how could I find a match between my two un-ordered columns and replace one of the column (Name1) with text from the second column (Name2) if a match is found in "Name2" .
Note: column Name1 is a subset of column Name2 and the text do not exactly match with those in Name2
For example;
Problem:
Name1 | Name2 |
Null | Puma Hospital |
Null | Anna Dispensary |
queen HC | queen Health Centre |
puma | St. Calro Dispensary |
Expected Solution:
Name1 | Name2 |
Null | Puma Hospital |
Null | Anna Dispensary |
queen Health Centre | queen Health Centre |
Puma Hospital | St. Calro Dispensary |
Solved! Go to Solution.
hey @jamte2006,
Looks like you'll need a fuzzy match here. I'm no expert in fuzzy match but there is a really good article here that explains all:
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485