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.
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 02 Support.