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!