Why is auto-dedupe not working?

Auto-dedupe excludes blank cells and cells with more than 200 characters from processing. [1] Check your LinkedIn Handle column for:

• Blank cells - these won't be deduplicated

• Values over 200 characters - these are also excluded

• Exact matches only - deduplication is case-sensitive, so "openai" and "OpenAI" are treated as different values [2]

• Extra whitespace - "openai " (with space) and "openai" aren't considered duplicates

If your data looks clean, try toggling auto-dedupe off and back on, then click "Save changes."

Is that what you were looking for?

No

I'm sorry that didn't help. I'll connect you to a human agent who can assist you further.

Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.

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!

Hey Siddhant - thank you for reaching out. Could you send me the URL to your table that you're having an issue with?

https://app.clay.com/workspaces/790547/workbooks/wb_0t5nswpn5PvJqaHzRue/tables/t_0t5nswpxSrojhPtJbKT/views/gv_0szl7gj87wnHpYQEih3

Thanks for sending that over! What you can do it first dedupe the column, then turn auto-dedupe to the setting you want. In order to dedupe the column, edit the column and press dedupe.

Hopefully after this column is deduped, auto-dedupe will dedupe new data. ​

It did help, and it handled de-duplication for a while, but then allowed duplicates to exist again after a while...

Ashwin D.

Thank you for your patience. Here's what I did:

I believe the auto-dedupe was glitching but it should hopefully work now.

We haven't heard back from you here, so we're going to go ahead and close this thread out.

Still need help here? Reply back and someone will jump back in.

Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!

Just FYI - this seems to be happening in other tables as well. Could I understand how the system works internally and what would be the time line to solve this permanently?

Hey Siddhant- just so I could get more clarity on this, you are deduping by LinkedIn handles, but can you confirm that the slugs are in the same format?

If you could send me the other tables where this is happening that would be great!