Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

How to Remove Duplicate Records in Clay by First and Last Name

Dakshin Karthik

·

·

Can someone help how to remove duplicates from the grids say if i have with same first name and last name bu a different middle name using clay?

How to Remove Duplicate Records in Clay by First and Last Name | Clay

6 comments

· Sorted by Oldest

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Patrícia Santos
·
·
The table is this one: https://app.clay.com/workspaces/310064/tables/t_Zc5A5MhntUsA/views/gv_zbyCdop9uQvw
Patrícia Santos
·
·
What an I looking is to have a unique table where, periodically, I can add new rows so you don't have to create new tables and repeat the entire setup process
Tanvi (Clay)
·
·
Hi Dakshin, thanks for reaching out! To remove duplicates, you can use the auto-dedupe feature to automatically remove duplicates for the column you select. You can turn on auto-dedupe in the bottom-right corner of your table: https://downloads.intercomcdn.com/i/o/1186232678/36a8db857148693a020b7134/AD_4nXfZW2M1GTowJYpzgmr2JMFZzo6JSAjOHwHHF8p0RQn48R0oKb0m9sGjR6uoGUSZ2iXdNSAkMOb6Ky2QSGova_gSP0aHmzrjQIJY89PyCYH-XzV6Cj3XPgjEWd4GHq3qORAMr8B3jaZKwL-T560JXNRQUrOf?expires=1726775100&signature=575a5cc5ecd8c9b23adc9f2345be4ef755f5c5a820bc5da07fbccdd5282605d6&req=dSEvEMt9n4dYUfMW1HO4zXvElJ7T%2BDcmrjZHC0oHJeixfmPKEWXAj6qr1lon%0AZ%2FviKbF%2FIVwmjg02ckY%3D%0A [App: Article Inserter] You can also dedupe via individual columns as shown below: https://downloads.intercomcdn.com/i/o/1186233321/4d76559b490a601cab316aee/AD_4nXcCNvbF94x_zhqbddxMgkqZjo45drGBEOxS-wwzLrvNC_WOKrSkBJvnc-dcB19FCTwpap-fW1qLCEBlFUWHU0f7L5gSwuwJfFRstvmiK96a1YG4JVHIPqmKt8kS29WjMubns_kS2ByFbDljd3ygmO0By5M?expires=1726775100&signature=98803455ae81bd4d13a50c6fc134cb6e99531dc21641ed2217dfb62efab652ff&req=dSEvEMt9noJdWPMW1HO4zb9V1nQVi7D9fa%2BD4HIfdsfyjXNx17bn2Omauh9a%0Az8td5iaL1qJQS2ChR7g%3D%0A Turning on auto-dedupe will allow you to create a table where each of the rows you add are unique values. Let me know if this answers your question and if there's anything else I can help with!
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 Dakshin Karthik! This thread was recently closed by our Support team. If you have a moment, please share your feedback: