Clay Icon

Merging Two Contact Tables to Update Job Titles and Employers Without Losing Data

·
·

Hey, I have 2 tables with the same contacts where table 1 has a lot of contact data but some of the contacts’ job titles and employers are outdates. Table 2 contains the same contacts but with updated job titles. I want to merge those two together and remove the outdated duplicates without deleting the additional contact data. I’m thinking about using the dedupe feature for this as a start. Question 1: If I use the dedupe feature on the full name where there are 2 or 3 of the same contacts, which one would the system remove? Question 2: How would you recommend I solve this?