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


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.


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.