Clay Icon

How to Remove Duplicate Contacts from Your Database Efficiently

·5 months ago·

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?

  • Avatar of Channeled
    Channeled
    APP
    ·5 months ago·

    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.

  • Avatar of Channeled
    Channeled
    APP
    ·5 months ago·

    Did that answer your question?

  • Avatar of James D.
    James D.
    ·5 months ago·

    is there anyway I can get credits back from duplications?

  • Avatar of Channeled
    Channeled
    APP
    ·5 months ago·

    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!

  • Avatar of Bo (.
    Bo (.
    ·5 months ago·

    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.

  • Avatar of James D.
    James D.
    ·5 months ago·

    hey Bo (. I spent 2,474 * 30 credits 😞 so 74220

  • Avatar of Bo (.
    Bo (.
    ·5 months ago·

    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!

How to Remove Duplicate Contacts from Your Database Efficiently | Clay