Home
Events
Groups
Members

01 Watercooler
02 Bugs
02 Starting with Clay
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

Powered by Tightknit

Deduplication of Company Column: Retaining Enriched Rows while Removing Duplicates

·

·

If I dedupe my company column, but some company rows have already been enriched, can I avoid deleting those ones and only remove if the enrichment hasn't happened on the row before?

Deduplication of Company Column: Retaining Enriched Rows while Removing Duplicates | Clay

4 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hi Nick, thanks for getting in touch! the quickest and easist way would be manipulating the data in a csv. But you can do it in Clay with a write to table function and conditionals (write to other table if the rows are enriched) if you share your table I think I would be able to help you better
Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_8ONS8hJBtbHF/views/gv_v9l4RjsMIPZU
Clay Team
APP
·
·
I see that this is a job table, so there won't be dedupe, my advice here is to export all the companies enriched to another table un run a lookup into our original table to copy the same enrichments depending on the company name. You can filter the first table to have only filled cells, then export to csv, import back in another table, and in the original table run the lookup for the table 2 to fill all the blanks if there is a company match
Clay Team
APP
·
·
The Lookup Record integration can help with that. Here's a video and our docs page for Lookup Record!