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?
Here is the table with all contacts merged in one: https://app.clay.com/workspaces/104458/tables/t_4QxU7UJ2Bl7C/views/gv_J1fxxnwhc924
Hey Ali, instead of combining and de-duping, you could instead use lookup record to just pull in the most recent title from table 2 into table 1
Perfect, thanks!