.png){kind=logo}
How to Check for Duplicate Entries in Clay Tables
Is there a way to check across all clay tables (or a selection of them) for duplicates so you don't end up emailing or contacting ones you've already contacted.
There are several ways to avoid contacting duplicate profiles across your Clay tables: 1. When creating a new people search: • Use the "Exclude people" section to remove profiles that appear in other Clay tables 2. Within an existing table: • Enable auto-dedupe by clicking the Auto-dedupe icon at the bottom right • Select the column you want to dedupe • Click "Save Changes" Alternatively, you can dedupe a specific column by: • Right-clicking the column • Selecting "Dedupe > Delete Duplicate Row" 3. Before running new enrichments: • Use Lookup columns to check if the data already exists in your CRM or other Clay tables • This not only prevents duplicate contacts but also helps save credits by avoiding duplicate enrichments Sources: Find People overview | Documentation | Clay University Auto-update and Auto-dedupe Table Guide: Ways to save Clay credits | Documentation | Clay University
Did that answer your question?
Hey there - we're having a bit of trouble with our support tooling and closed this conversation out preemptively. Reopening it here and someone from our team will get back to you soon!
Anaum K.··Hello Mark! Thank you for reaching out! 👋 You can check for duplicates across Clay tables using our Lookup integration. For a detailed walkthrough, please watch this video tutorial. If you have any additional questions or run into any issues, please don’t hesitate to let me know—I’m here to help! 😊