Automate 'Dedupe' Function to Delete Duplicate Values in CSV Column

·Feb 19, 2024 04:12 PM·

Hey team, is there a way to automate the 'Dedupe' function to automatically delete duplicate values in the column (two or more rows with the same value, not a list of values in a single row) every time I add leads to the existing table?

👀3

4 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Hi, Im afraid this is not possible
Lance G.
·
·
Ouch, I was worried it would be like that. Thanks a lot for the answer! It would be great if you could add that kind of enrichment in the future. It'd be really helpful for automating campaigns and avoiding errors. :)
Tyler C.
·
·
Hey Lance G. you can filter out duplicates but it requires a second table. There’s no way to do exactly what you asked but you can get a similar result with a workaround.

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Hi, Im afraid this is not possible
Lance G.
·
·
Ouch, I was worried it would be like that. Thanks a lot for the answer! It would be great if you could add that kind of enrichment in the future. It'd be really helpful for automating campaigns and avoiding errors. :)
Tyler C.
·
·
Hey Lance G. you can filter out duplicates but it requires a second table. There’s no way to do exactly what you asked but you can get a similar result with a workaround.