Deduplicating Employees by Highest Score in Company Name Column

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.

4 comments

Channeled
APP
·
·
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
Ned T.
·
·
It does, thankyou so much!
Channeled
APP
·
·
That's great! I'm happy to answer more questions if you have them.
Channeled
APP
·
·
Hi Ned T.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: