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?

4 comments

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!