This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.