.png&w=3840&q=75){kind=logo}
How to Remove Duplicate Records in Clay by First and Last Name
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?
💤 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!
The table is this one: https://app.clay.com/workspaces/310064/tables/t_Zc5A5MhntUsA/views/gv_zbyCdop9uQvw
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 R.··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!
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!
Hi Dakshin K.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: