Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

How to compare text in two columns that are not ordered

Highlighted

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:

Name1Name2
NullPuma Hospital
NullAnna Dispensary
queen HCqueen Health Centre
puma St. Calro Dispensary

 

Expected Solution:

Name1Name2
NullPuma Hospital
NullAnna Dispensary
queen Health Centrequeen Health Centre
Puma HospitalSt. Calro Dispensary
Highlighted
Alteryx Certified Partner

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

Alteryx Partner

 

This will do it:

 

 

2018-02-15_00075.png

Labels