Preventing Duplicate Contacts in Table Enrichment Operations

Hello! I'm using the "Find Contacts at Company" enrichment and then using the "Write to table" enrichment to copy those contacts to a separate table. I'm seeing an issue where "Find Contacts at Company" returns a list containing duplicates. What's the best way to prevent these duplicates? Is there something I could configure in either enhancement?

10 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Vlad T.
·
·
Org Table: https://app.clay.com/workspaces/147954/tables/t_l8WifeFdP79M/views/gv_y8KcTe4QCIhn Contact Table: https://app.clay.com/workspaces/147954/tables/t_xP7nqM44FYee/views/gv_xZn2A8JBOqku
Clay Team
APP
·
·
Hey Vlad!!
Clay Team
APP
·
·
I can surface this with our team, it may be an issue where the domains were added twice by the integration so we can remove them. Did you come across many of them or just one in particular?
Clay Team
APP
·
·
There is a way to use Javascript with Write to table to check the list and only pass over unique values, but will do some digging to find the formula for you if it helps
Vlad T.
·
·
that would help! It happened a couple of times, it's rare. Ultimately it just saves a few credits bc my integration with smartlead will prevent a duplicate lead anyway
Vlad T.
·
·
+ it would help with ensuring that I get an extra unique lead
Clay Team
APP
·
·
Yup, just a second. Looked it up but may need tweaking for this specific scenario
Clay Team
APP
·
·
Could you run a test with this one, maybe write to a test table before you continue with your main one? You can also replace the "personid" with the "url" but guessing both should work .uniqBy({{Find Contacts at Company}}?.people, 'personid')
Clay Team
APP
·
·
Or let me know if you need help with the setup and which rows have duplicate profiles we can test it on

Preventing Duplicate Contacts in Table Enrichment Operations | Clay