How to Remove Duplicate Contacts from Your Database Efficiently

James D. · 2025-02-27 14:45:25.729904+00

hey - I have a table that has somehow duplicated contacts, is there a way of me clearing that out? Its super annoying as I has enrichments running and now its blowing a bunch of credits on duplicated data.. know why this is happening?

How to Remove Duplicate Contacts from Your Database Efficiently | Clay

8 comments

· Sorted by Oldest

Channeled
APP
·
·
You have several options to handle duplicate contacts: 1. Use Auto-dedupe (Beta): • Click the Auto-dedupe icon at the bottom right of your table • Select "Enable automatic deduplication" • Choose the column to dedupe against • Click "Save Changes" 2. Manual Column Deduplication: • Click the header of the column containing duplicates • Select "Dedupe" from the dropdown • Confirm and select "Delete" to remove duplicates Note when deduplicating: ** Deleted rows cannot be recovered ** Matches are case-sensitive * Extra whitespace is considered in matching The Auto-dedupe feature is specifically designed to keep your table clean and prevent accidentally enriching the same record multiple times.
Sources: New at Clay | Clay.com Auto-update and Auto-dedupe Table Table columns overview | Documentation | Clay University
Channeled
APP
·
·
Did that answer your question?
James D.
·
·
is there anyway I can get credits back from duplications?
Channeled
APP
·
·
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
James D.
·
·
https://app.clay.com/workspaces/434146/workbooks/wb_oFYxi2BVJWes/tables/t_osMPkDXTVWtE/views/gv_6ysyQFvBZhRi
Bo (.
·
·
Hi James,
Auto-dedupe is the way to go. If the data is in another table you can also use lookup.
If you'd rather not delete the data you can also use this method here. Here's the formula as well: {{Unique ID}}?({{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())> -1?{{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())+1:2):2
Regarding the refund of credits, happy to do so. How many was it? Just FYI we won't be able to do so anymore.
James D.
·
·
hey Bo (. I spent 2,474 * 30 credits 😞 so 74220
Bo (.
·
·
Hey James!
I added 7,422 credits to your account. Just FYI, we won't be able to do this anymore, so let's make sure we prevent this from happening again!
Let me know if you need anything else!

Channeled
APP
·
·
You have several options to handle duplicate contacts: 1. Use Auto-dedupe (Beta): • Click the Auto-dedupe icon at the bottom right of your table • Select "Enable automatic deduplication" • Choose the column to dedupe against • Click "Save Changes" 2. Manual Column Deduplication: • Click the header of the column containing duplicates • Select "Dedupe" from the dropdown • Confirm and select "Delete" to remove duplicates Note when deduplicating: ** Deleted rows cannot be recovered ** Matches are case-sensitive * Extra whitespace is considered in matching The Auto-dedupe feature is specifically designed to keep your table clean and prevent accidentally enriching the same record multiple times.
Sources: New at Clay | Clay.com Auto-update and Auto-dedupe Table Table columns overview | Documentation | Clay University
Channeled
APP
·
·
Did that answer your question?
James D.
·
·
is there anyway I can get credits back from duplications?
Channeled
APP
·
·
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
James D.
·
·
https://app.clay.com/workspaces/434146/workbooks/wb_oFYxi2BVJWes/tables/t_osMPkDXTVWtE/views/gv_6ysyQFvBZhRi
Bo (.
·
·
Hi James,
Auto-dedupe is the way to go. If the data is in another table you can also use lookup.
If you'd rather not delete the data you can also use this method here. Here's the formula as well: {{Unique ID}}?({{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())> -1?{{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())+1:2):2
Regarding the refund of credits, happy to do so. How many was it? Just FYI we won't be able to do so anymore.
James D.
·
·
hey Bo (. I spent 2,474 * 30 credits 😞 so 74220
Bo (.
·
·
Hey James!
I added 7,422 credits to your account. Just FYI, we won't be able to do this anymore, so let's make sure we prevent this from happening again!
Let me know if you need anything else!