How can I match values in the email address field to values in alternate/other email address fields in my CRM?
DemandTools now supports cross-field matching in the Dedupe module. Cross-field matching enables you to find matching values across up to 5 different fields on a single object. For example, if you wanted to return matches where values in the standard email address field and an alternative email address field are the same. Another use case would be to find matching values in the Business Phone, Mobile, or Other Phone fields match.
To set up cross field matching, go to the Fields to Compare step in the Dedupe module. You will see the Cross-Field Match option on the left-hand side of the Fields to Compare table. Once this box is checked, you will have the option to compare up to 5 fields.
Results returned will have a matching value in any of the fields selected in the previous step.