Trying to dedupe a list, but really I'm also trying to merge values across these dupes. It seems like the native dedupe feature in Clay will normalize and identify the dupes, but then delete one. In this example, I want to effectively merge these duplicates into a single row, keeping all the information. Any easy way to do that? In this case, the duplicates are from separate lists and shouldn't have any overlapping populated columns other than Company name and domain
there is not an easy way to do this -- I'm curious where are you getting the company rows from?
Two lists from a couple of CSV uploads, one is CRM accounts, one is specific award winners that I did a bit of AI enrichment on before attempting to merge and dedupe the lists
awesome -- CRM should have a way to dedupe before bringing in the list to enrich in Clay. Clay is not really purpose built to do deduping
so if I was in your shoes I'd take award winners --> merge into CRM and take a unique identifier to manage duplicates in CRM (e.g. domain) --> put these award winners in a list --> then bring into clay for enrichment --> lookup/update/create in clay to CRM
hope that helps
Thank you, yeah, figured I'd have to do something along those lines, aka how I should've approached it in the beginning. Given I already had both in Clay, with the non-CRM list enriched already, I was hoping I could achieve it within Clay
