Clay Icon

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

·6 months ago·

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 t.
    kushagra t.
    ·6 months ago·

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

  • Avatar of kushagra t.
    kushagra t.
    ·6 months ago·

    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.
    ·6 months ago·

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

  • Avatar of Loic B.
    Loic B.
    ·6 months ago·

    That's exactly what I was looking for

  • Avatar of kushagra t.
    kushagra t.
    ·6 months ago·

    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.
    ·6 months ago·

    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.
    ·6 months ago·

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

  • Avatar of Loic B.
    Loic B.
    ·6 months ago·

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

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