Merging Two Tables to Avoid Duplicates in Clay Database

Hi Team. Context: Lets say I got 100 people from running a Clay People Table using Clay Database into Table 1. Now lets say I also want to import from external Database another 100 people into Table 2. Concern: How I I merge the tables so that there is no People duplicates in the Final Clay People Table which need to be further enriched based on my Claygent template setup. A simple Merge and then remove duplicates would work? Thanks.

3 comments

Channeled
APP
·
·
To merge two tables in Clay without creating duplicates, you can use our "write to table" feature and then deduplicate the data. Here's how: 1. Use the "write to table" integration to transfer data from Table 2 to Table 1. 2. After transferring, use the "Normalize and Deduplicate a List" feature to remove duplicates. 3. To align with your Claygent template, ensure you map the columns correctly during the "write to table" process. This approach will merge your tables and remove duplicates in the final Clay People Table, ready for further enrichment based on your template setup.
Sources: Write to Other Table | Documentation | Clay University Normalize and Deduplicate a List with Clay
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
We haven't heard back, so we're going to go ahead and close this out. Feel free to click the "Talk to a Human" button above if you still need help!
1