Clay Icon
Join the Community
02 Support

Deduplication of Company Column: Retaining Enriched Rows while Removing Duplicates

Avatar of Nick S.Nick S.
·
·

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

  • Avatar of Clay Team
    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

  • Avatar of Clay Team
    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

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    The Lookup Record integration can help with that. Here's a video and our docs page for Lookup Record!