Clay Icon

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.

  • Avatar of Channeled
    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

  • Avatar of Ned T.
    Ned T.
    ยท
    ยท

    It does, thankyou so much!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    That's great! I'm happy to answer more questions if you have them.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Ned T.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: