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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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

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
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