Clay Icon

How to Deduplicate a List to Keep Only 4 Records per Domain

ยท
ยท

Is it possible to dedupe a list by saying: Only keep 4 records of {company domain}?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Yes, it's possible to deduplicate a list in Clay, but the specific functionality to keep only 4 records per company domain isn't directly available. However, we have options that can help you achieve a similar result: 1. Use the "Dedupe" feature: Click on the company domain column header and select "Dedupe" from the dropdown. This will remove all duplicates, keeping one record per domain. 2. Utilize our Auto-dedupe feature: This automatically deletes duplicate records, helping keep your data clean and reducing spend on accidentally enriching the same record twice. To limit to 4 records per domain, you might need to use our "write to table" integration with custom logic. If you need further assistance with this specific requirement, please request human support for a more tailored solution.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Did that answer your question?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

  • Avatar of Philipp K.
    Philipp K.
    ยท
    ยท

    Doesn't help - if anyone has solved (pretty sure most have had this problem since you are likely not reaching out to 30 people at the same company at the same time) i'm all ears!