Automate Deduplication of Data When Writing to Another Table

Oleh M. · 2025-03-14T07:25:03.224684+00:00

Now when I press "Write to Other table" every day, I can see that the data is duplicated. But I want to remove the duplicates and write the deduplicated data to another table. I want to do this automatically. How can I do this?

To automatically remove duplicates and write deduplicated data to another table in Clay, you can use a combination of auto-dedupe and the "write to table" feature. Here's how: 1. Set up auto-dedupe on your source table: • Click the Auto-dedupe icon at the bottom right of your table • Enable automatic deduplication • Select the column to dedupe • Click Save Changes 2. Use the "write to table" feature to transfer data: • Click "Add Enrichment" and search for "Write to Table" • Select your destination table • Map the columns from your source to the destination table • Enable Auto-update in the run settings This setup will automatically deduplicate your source data and transfer the clean data to another table.

Sources: Write to Other Table | Documentation | Clay University New at Clay | Clay.com Auto-update and Auto-dedupe Table

2 comments