Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Automate Deduplication of Data When Writing to Another Table | Clay

Automate Deduplication of Data When Writing to Another Table

·Mar 14, 2025 07:24 AM·

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?

2 comments

· Sorted by Oldest

Channeled
APP
·
·
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
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.