Hi everyone! A question. I need to enrich the companies in a column, but there are duplicates in this column (I can’t delete them because under one company there are several contacts). How can I set up the action or which formula should I use so that enrichment is done only once per company and not repeated for duplicates? When gave de-duplication instructions -those didn't help (clay burnt credits anyway) TY!
Use send table data to write your data to another table. Then you can dedupe the second table by company name or domain, without worrying about data loss. Then you can run your company enrichments in your unique companies table, and use the 'lookup single row in other table' enrichment back in your people table to pull the data back in to your people table.
I've made some videos on this! https://youtu.be/FyHvtRg3yFo?si=NP1KJMZt-F3sln2U https://youtu.be/HmE6dbNAI3c?si=jp8hSBiEnvwpMsKW
Use Send Table Data to copy your data into another table. From there you can deduplicate by company name or domain without risking data loss. Once you have a clean set of unique companies, run your company enrichments in that table. Finally, use the Lookup single row in other table enrichment to pull the enriched company data back into your People table. Hope that helps!
Use Send Table Data to copy your original dataset into a new table. This lets you safely deduplicate by company name or domain without risking any data loss in your main table. Once you’ve isolated a clean set of unique companies, run your company enrichment workflows within that new table. After enrichment is complete, use the Lookup single row in other table enrichment to pull the enriched company data back into your original People table by matching on domain or company name. This approach ensures your enrichments remain accurate and your original data stays clean and organized.
Thank you guys for your help! Appreciate it!
Welcome!
your welcome
