I am using Panorama to clean up a contact list from a customer database prior to importing contacts into an email marketing platform. For the marketing platform I can only have one record associated with an email address. However, in our old customer db, we have many records with duplicate emails, particularly where a contact’s email was associated with a company.
I want to clean-out email addresses that are not the primary address for a singular contact.
I ran ‘selectduplicates’ to find all of the records where the email address is a duplicate and it is returning many partial duplicates. For example…
aadams@…
aagolubi@…
aaguirre@…
Is there a procedure or formula I can use that will only select complete duplicates. For example…
aadams@…
aadams@…
Thanks