Clay Icon

Conditional Column Execution Based on Domain Presence in Rows

ยท
ยท

Hi, I'm looking to run a column only up to the row that doesn't have a domain associated with it. Is there a way to do this? Having played with the "only run if" function didn't get me the desired result so far

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can achieve this in two ways: 1. Using Conditional Runs: โ€ข Go to the "Run Settings" of your enrichment column โ€ข Click on "Conditional Run" โ€ข In the "Only run if" box, add a formula that checks for the presence of a domain โ€ข You can use the "Use AI" button to help generate the formula in plain language 2. Using Filters: โ€ข Add a filter condition to exclude rows with empty domain cells โ€ข This will ensure the enrichment only processes rows that have domain valuesBoth methods will help you optimize credit usage by preventing the column from running on rows without domain data. Source: Guide: Ways to save Clay credits | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Is that what you were looking for?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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

  • Avatar of Faheem G.
    Faheem G.
    ยท
    ยท

    Use conditional formula

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Here's how to set up a conditional formula to only run on rows with domains: 1. Go to the enrichment column's "Run Settings" 2. Click on "Conditional Run" 3. Click "Use AI" and type something like "Only run if /domain is not empty" (use "/" to reference your domain column) 4. Click "Generate Formula"The conditional run works like an if-else statement - it will only run the enrichment when the condition is true (when there's a domain present) and skip rows where the domain is missing.You can also type this directly in the conditional formula box, or use the AI to help generate more complex conditions if needed. Sources: Conditional runs | Documentation | Clay University Conditional Formulas

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Did that answer your question?