Clay Icon
Join the Community
02 Support

Preventing Repeated Enrichment on the Same Domain in Ask AI Enrichment for Find People Table

Avatar of Joe H.Joe H.
·
·

Trying to write a conditional formula that prevents the Ask AI enrichment in a Find People table from running multiple rows with the same domain (company). Specifically: I have 3 prospects at a company and will use the Ask AI output to personalize an email to these prospects (at the same company). I only need the company-specific output once, because it applies to all 3 prospects. Not sure how to accomplish this through the conditional formula - screenshot attached of my attempt!

10 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hi Joe, thanks for getting in touch! In this case I would create another identical table throught a csv import export, dedupe all the domains, use Ai to create the message, and then through a lookup function input all the messages in the original table based on the domain: Here's a video and our docs page for Lookup Record!

  • Avatar of Joe H.
    Joe H.
    ·
    ·

    Juan P. Arturo O. Thanks team - is there an easy way to dedupe strings (cells) in a column in my Clay table? I know a function exists for multiple strings in a single cell, but I’m looking to remove duplicate unique strings in a column. For ex: Company Column:

    • Adobe

    • Workday

    • Adobe

    • …and so on

    How would I go about efficiently removing the excess Adobe strings? Can do this in Excel too, just wondering if possible in Clay right now (Airtable has this function on their paid plans fwiw 😄)

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Joe!! Yes, are these comma-separated strings? We have a Normalize and dedupe integration or you can also ask the formula generator in a new column to clean that up for you :)

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    I personally use the formulas a lot more but this is the integration that could help too

    d7cc0d40-bf89-4c8f-aa01-a07fe5b42782.png(15 kB)
  • Avatar of Joe H.
    Joe H.
    ·
    ·

    Hey Arturo O. Thanks for following up here. I’m still not totally clear on how to accomplish this in a Clay table - maybe I’m using the formula incorrectly? Attaching this Loom for crystal clear context:

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Thanks for the video, Joe! It came down to us not understanding or misunderstanding what you wanted to achieve here. To remove duplicates you can click on the column header with the duplicate values and in the dropdown menu you'll find the "dedupe" button. Here's a quick video about deduping in Clay: https://www.loom.com/share/4d10c62c49f14df593f32012bd2c3017

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Joe H., let me know if you have additional questions or if you run into other issues!

  • Avatar of Joe H.
    Joe H.
    ·
    ·

    Arturo O. you guys are the best. * facepalm * this was way simpler than i thought!