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?
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 ๐
Hey Vlad!!
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?
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
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
+ it would help with ensuring that I get an extra unique lead
Yup, just a second. Looked it up but may need tweaking for this specific scenario
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')
โ
Or let me know if you need help with the setup and which rows have duplicate profiles we can test it on