Clay Icon

How to Instruct AI to Skip Empty Values in Data Enrichment Process

·
·

Hello everyone, I am facing an issue that some of you may have already encountered. I have a column with an AI agent, and I want this agent to check the values of different columns and compare their content to a company domain contained in another column. My problem is that some of the columns to be checked may be empty (which could be expected), causing the enrichment process to fail because it considers the missing values as an issue (the company domain is never empty). Is there a way to instruct the agent to simply skip empty values? I have tried different prompts and used generative AI, but I keep encountering the same issue. Thanks for your help!

  • Avatar of kushagra
    kushagra
    ·
    ·

    When you reference the column in the prompt there's a blue toggle, just switch that off. 🙂

  • Avatar of kushagra
    kushagra
    ·
    ·

    this blue toggle in the image - if you switch it off that means the enrichment will run even if it is empty does this solve it? or maybe i am understanding your question wrong

  • Avatar of Loic B.
    Loic B.
    ·
    ·

    Looks perfect, thx a lot, it fix my issue, appreciate that

  • Avatar of Loic B.
    Loic B.
    ·
    ·

    That's exactly what I was looking for

  • Avatar of kushagra
    kushagra
    ·
    ·

    awesome, happy to help i learnt it the hard way too, realised one day that that blue toggle is supposed to do something and is not just to catch attention haha

  • Avatar of Loic B.
    Loic B.
    ·
    ·

    yep same thing here, I was going crazy and just with little blue toggle, my pb are going away, you made my day

  • Avatar of Raghav C.
    Raghav C.
    ·
    ·

    Another alternative that I use is to filter out the empty rows first by applying “is not empty”

  • Avatar of Loic B.
    Loic B.
    ·
    ·

    yeah but in my case, the row is not empty just soe columns, so this toggle is perfectly working as expected. Thx again