This is by far the most annoying clay bug. GPT columns (and others but usually AI columns) output results mostly to one column, but some columns have a blank result despite the enrichment itself having a value. In that enrichment I can create a new column with the value, and then create a merge column to have one source of truth.
I totally get how frustrating this inconsistent AI column output is! This usually happens when the column was changed multiple times, updated, or if the run was stopped midway.
The quickest fix is to duplicate your current AI column and run it only on the empty rows. Filter for rows where the original column "is empty," then run the AI on those filtered rows. After that, use the merge columns feature to combine both results into one source of truth.
Another potential cause could be the output definition in your prompt configuration - make sure the output fields are correctly defined and mapped in your prompt settings.
Have you tried stopping and restarting the AI column, or did this happen after making changes to the column settings?
If you still need help resolving the AI column output issue, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other challenges you’re facing with the columns?
human
Would you like me to connect you with a human agent? Or if you provide more details about your issue, I can continue to assist you.
yes
I’m routing you to our human team now. They’ll be able to assist you further.
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Hello Jacob I also have this issue sometimes. What I realized is that there is no need of creating another column and merging. You can select the results of the AI column in which is empty and select the output and the same column where you want to results. It will remap the column and the results that were already showing and the ones that were not showing should appear
Hi Jacob,
Let me know if you still have any questions!
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!
