Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

How to Automate Deletion of Duplicate Rows in Your Workplace

·Jan 07, 2025 11:29 PM·

Hi! How can we delete duplicate rows in a workplace? Our API with our Apify actor keeps sending in dupes, and we need to create an automation to scrape every row and delete anything that’s a duplicate!

How to Automate Deletion of Duplicate Rows in Your Workplace | Clay

5 comments

· Sorted by Oldest

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch soon. 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!
Owen C.
·
·
Hey Saman, thanks for reaching out! To remove duplicates from your table, you'll need to use our "Auto-dedupe" function. Simply select the button at the bottom-right, as shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1325326549/aec49b3ebe564b25954e0ba30098/CleanShot-2B2024-12-05-2Bat-2B09_37_24-402x.png?expires=1736294400&signature=5825d90f520737d15925e0f3b1128181c0b7329b8939ccb233a4c4bbe86b18f9&req=dSMlE8p8m4RbUPMW1HO4zbv9lWqZT0ctLlmKi%2FNT84q9RQ%3D%3D%0A From the menu that appears, toggle on "Enable automatic deduplication." Then, under "Dedupe via column," choose a column that serves as a unique identifier for each row. For instance, if you're working with people and two individuals share the same LinkedIn URL, they are likely the same person, so you would select the LinkedIn URL as the deduplication column. https://downloads.intercomcdn.com/i/o/w28k1kwz/1325326547/d7231220106997c4e23d5a3eb238/CleanShot-2B2024-12-05-2Bat-2B09_37_48-402x.png?expires=1736294400&signature=443a76b8855843680a583765b061dca7449857ef02eed1ca7237d7e3e766db63&req=dSMlE8p8m4RbXvMW1HO4zUN9dTKbtILky%2BaxEECuCSqt4g%3D%3D%0A Next, click "Save changes," and this will automatically remove any duplicate leads. Hope this helps! Let me know how else I can assist here. :)
Saman I.
·
·
Owen C. you are an absolute gem! Thank you so, so much! I was losing my marbles and it was right under our nose this whole time. Thanks again ❤️
Channeled
APP
·
·
Hi Saman I.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Saman I.!