Hi, looking to deduplicate people who work at the same company. I will be deduplicating the company name column There are three people, who are individually scored 15, 10, and 5 I want the highest scored person to be left after running the deduplication.
You can use Clay's Normalize and Deduplicate integration to handle this. Here's how:1. First, make sure you have a column with your scoring values (15, 10, 5 in your case) 2. Use the Normalize and Deduplicate integration on your company name column 3. When configuring the integration: โข Input the list of company names you want to deduplicate โข Enable "Remove empty values" if needed โข The integration will return both a deduped list object and a deduped stringThis will help standardize your company names and remove duplicates while preserving the entries with the highest scores. Source: Normalize and Deduplicate a List with Clay
It does, thankyou so much!
That's great! I'm happy to answer more questions if you have them.