community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Check data in two fields and return common values in a third field

Highlighted
Asteroid

I have two columns with addresses from two different sources. I need a third column to return the common street names if any from the two columns. How do I go about matching the data in the two columns?

Alteryx Certified Partner

Address fields can be tricky with formatting. I recommend running both sources through CASS to standardize the addresses before attempting a match. 

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-CASS/ta-p/29898

 

After that, there's a few ways to go about matching depending on exactly how you want to approach it. I've attached a quick example of string matching I put together to start the conversation. This would also be a great opportunity to look into Fizzy matching.

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485

Labels