Clay Icon
Join the Community
02 Support

How to Remove Duplicate Contacts from Your Database Efficiently

Avatar of James D.James D.
·
·

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?

8 comments

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Did that answer your question?

  • Avatar of James D.
    James D.
    ·
    ·

    is there anyway I can get credits back from duplications?

  • Avatar of Channeled
    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!

  • Avatar of Bo (.
    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.

  • Avatar of James D.
    James D.
    ·
    ·

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

  • Avatar of Bo (.
    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!