Join the Community

01 Community General

01 Community General

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!

8 comments

kushagra t.
·6 months ago·
When you reference the column in the prompt there's a blue toggle, just switch that off. 🙂
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
Loic B.
·6 months ago·
Looks perfect, thx a lot, it fix my issue, appreciate that
Loic B.
·6 months ago·
That's exactly what I was looking for
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
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
😄1
Raghav C.
·6 months ago·
Another alternative that I use is to filter out the empty rows first by applying “is not empty”
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
1

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