Joinin on Email

mroker · 2023-07-05T13:16:12+00:00

There was an error rendering this rich post.

I have 2 contact databases where I need to join them based on both phone number, name, and email. I am able to currently join on phone but the email part I am having an issue with. When trying to join on email it isn't working. What is the best way to join on email address and if possible where emails closely match?

Find more posts tagged with

Magic ETL

Accepted answers

MarkSnodgrass

You might need to define closely match. The first thing I would try would be to use the TRIM() and LOWER() functions on both addresses to remove any hidden spaces and eliminate any case sensitivity issues.

All comments

MarkSnodgrass

mroker

Thank you for this Mark. I meant using a fuzzymatch type of algorithm. For example, if I wanted to match 'Michael' and Mihcael'.

Thanks for the youtube list! Much of these will be helpful to me.