How to compare text in two columns that are not ordered

[jamte2006]

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

[LordNeilLord]

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

[derekbelyea · Accepted solution]

This will do it: