How to Remove Duplicate Entries from Your Clay Table Efficiently

Hi! I like to find an easy/quick way to remove dublicates from my clay table. Ofc there is the "Dedupe" function, which keeps the first appearance. Unfortunately I want to delete the first appearance (or in best case both appearances), since I copy paste already contacted companies underneath the table and try to fully delete them from the table. Any ideas? Thanks Stefan

7 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Stefan F.
·
·
Btw I also tried to exclude them from the very beginning with the beta function "exclude companies", but unfortunately it does not show any tables there, just folders to select.
Tanvi R.
·
·
Hi Stefan, thanks for reaching out! Do you mind sending the table url with your request as well? This allows us to assist you better 😊 https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1727120700&signature=d0a2f9bc774d0aaad67d1fe50fe4355719caff2f18ac29ccaf7ff9650c6ed005&req=dSEgF85%2FmohWX%2FMW1HO4zYTywCz9BJcR2BKsam%2FhVPsD4g%3D%3D%0A The exclude companies feature is currently not included on the free trial, but if this is something you would like to try I'm happy to unblock it for you - let me know!
Stefan F.
·
·
Hi Tanvi, thanks for Your help! I'm working in this account, here is the link: https://app.clay.com/workspaces/263760/tables/t_6CCxMj5Yq2Qx/views/gv_KmyiyKujhEso
Tanvi R.
·
·
Hey Stefan! If you are looking to delete both records of a domain in your table, since there are only a few values that you pasted I would just use the filter view to filter for where the domain contains the matching keywords as I've shown below https://downloads.intercomcdn.com/i/o/1190383853/dff6d321ef7f7a4fe724f68d/CleanShot+2024-09-23+at+18_16_16%402x.png?expires=1727131500&signature=5daa0aa6e46cf9d7e00d9130e158471ed790d93e233c5f1b00caad6a5006ba1c&req=dSEuFsp2nolaWvMW1HO4zTPedaiLbmUl3UQHzsXTpriPtLlQe5o%2F%2BS0aCXaE%0AnkE9%0A You can then select all rows in this filtered view, right click, and then delete them https://downloads.intercomcdn.com/i/o/1190385391/2f865b9e3f6165034fd84e6d/CleanShot+2024-09-23+at+18_18_02%402x.png?expires=1727131500&signature=3432527f11c567fbace203f6a5fc665d66d1846c558446235125a6791f7ef2f9&req=dSEuFsp2mIJWWPMW1HO4zUEf%2B8hHZdy12Enmbjo79M3H%2FCECm76HI9aX36Eb%0AA6xz%0A Deduping will still keep the first appearance of this value as you've said. In the future, I'd recommend using the exclude companies filter here! I've enabled that for you for the next 2 weeks to try out :) Let me know if you have any other questions! 😊
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Stefan F.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: