How to Avoid Duplicate Companies in Multiple Tables or Consolidate into One List for Deduplication

Hey, I'm creating multiple company table - is there a way to ensure these tables would have no duplicates in each (company A on list 1 is also added on list 2 or list 3). Or how should we consolidate this into one list so we can perform dedupe instead.

4 comments

Matthew A.
·
·
Hey Raymond, just tried out what you're talking about in my own Clay instance. If you want to consolidate lists without burning credits this is what I would recommend doing. Pull however many profiles for companies using the basic LinkedIn profile (don't enrich yet). Continue running the basic enrichment for however many times you want to add companies to the table. because there is the search limit we have to work around. Before you make any credit burning adjustments, use the Dedupe function to clear out all the duplicates. after you've run the basic company enrichment however many times. Hope this is somewhat useful. DM if you're still having trouble. 🙂 If you want t
🔥1
Raymond J.
·
·
You mean, i'll perform the searches outside clay and consolidate them via csv upload so I'll only create one main table for all these search variation prior performing enrichments?
Clay Team
APP
·
·
Hey Raymond, thanks for reaching out! I think Matthew's approach is very useful. QQ though in case you're using something else to generate these lists— are you using the Find Companies from LinkedIn option to create these lists? If so, then just like Matthew said, you can run multiple searches and import into the same company table all of the results, then dedupe them before you enrich any of them.
Clay Team
APP
·
·
Otherwise, if you'd like to keep separate tables but want to delete any duplicates between them then you can use the Lookup Record integration to help with that. Here's a video and our docs page for Lookup Record!