Removing Duplicates from a Table and Writing to Another Table

Hey Utkarsh! Thanks for reaching out. Happy to help. To confirm, you'd like to remove duplicates and send the records that remain to a new table? Here's a quick recording showing how to remove duplicates and enable auto-dedupe in your table: https://share.cleanshot.com/JSkGJwBW To remove duplicates you can click on the column header with the duplicate values and in the dropdown menu you'll find the "dedupe" button. Additional video about deduping in Clay: https://www.loom.com/share/4d10c62c49f14df593f32012bd2c3017 Here's a quick guide for using the write to other table integration: https://www.loom.com/share/d46fd74ae9004d229142a2474ac61866?sid=440fafc1-5d4c-4ed4-bebe-449748573397 Let me know if this helps.

And let’s say I have a table of companies and I want to import more companies via csv But csv has some companies which has some companies which are already in the table How do I remove that?

Hey Utkarsh: 1. Import 2. Dedupe or Auto-Dedupe for having this done automatically :) https://downloads.intercomcdn.com/i/o/1180058594/8548639caeb2e9d2dbac2298/CleanShot+2024-09-14+at+_56gAaxAf84%402x.png?expires=1726328700&signature=cca78e6348bc2f5900323a6d64c8a91430f8e6d8adcfdcac5fc871e57b8979d9&req=dSEvFsl7lYRWXfMW1HO4zQfh24rF4wANA40J%2FBNOtWSP1C4YaPzm%2FNBLLG%2BO%0A5Myi%0A https://downloads.intercomcdn.com/i/o/1180058376/6ab69e7e714664e2ee3a603d/CleanShot+2024-09-14+at+_35TODgSHPx%402x.png?expires=1726328700&signature=4e724cb344b664b45039bde1eb5e7d22252ad94c100d074d6a1d27ba8397c98a&req=dSEvFsl7lYJYX%2FMW1HO4zWOuluAxrMDSmNPROumaSJqU52uWRkA8PuB6Z%2B2A%0AIrTD%0A

How to turn on auto deduping

Like this 🙂