Hi team, I have some columns where the value depends on which enrichment within a waterfall sequence is successful. However I noticed some rows (e.g. row 374-375) got empty value even though one of the enrichment in waterfall is successful. Just rerunning the enrichment again works but it's extra cost for no reason, any idea why this happened and what's the fix? Anything wrong with the column's formula?
This issue typically occurs when enrichments don't run in the correct sequence or when the data hasn't been properly updated. Here's how to address it: 1. First, check if the enrichment is showing "waiting for its inputs" by double-clicking the row. If so, you can simply click "re-run this cell" for the specific rows affected. 2. For a more systematic approach: • Toggle the auto-update off and then on again • Accept the run prompt to update all affected rows To prevent this from happening in the future, consider adding conditional run settings to ensure enrichments only run when all required input data is present. This gives you better control over the enrichment process and helps avoid empty values. Remember that in a waterfall sequence, even if an enrichment is successful, it will continue to the next provider if the specific data point you want isn't found in the current enrichment.
there's only 1 input for the enrichment (company domain) and it always exists
as you can see in the screenshot, the enrichment is already successful
This behavior is actually expected in waterfall enrichments. Even when an enrichment is successful, if that specific provider doesn't have the particular data point you're looking for, the waterfall will continue to the next provider. For example, a provider might successfully identify and match the company from the domain, but not have the specific information (like funding stage, tech stack, etc.) that you're trying to collect. In this case, the enrichment would be marked as successful, but the specific data field would remain empty and the waterfall would continue to the next provider. To get the best results, make sure you're using appropriate providers in your waterfall sequence that are likely to have the specific data points you're looking for. The domain is indeed your "corner piece" for company enrichment, but each provider may have different strengths in terms of what company information they can provide.
it's just the columns which should be filled by the enrichment result remains empty
This is actually expected behavior in waterfall enrichments. Even when an enrichment is successful in matching a company, it might not have the specific data point you're looking for. In this case, the enrichment will be marked as successful, but the particular field will remain empty and the waterfall will continue to the next provider. For example, if you're looking for funding stage data: ** Provider A might successfully identify the company but not have funding data ** The waterfall will then check Provider B for the same information * This continues until either the data is found or all providers are checked Looking at your provider columns is the best way to understand how the waterfall is working. All providers will ultimately feed their data into one final result column for use in your Clay table.
To fix empty columns when an enrichment is successful, try these steps: 1. Make sure you've properly added the data fields as columns: • Click on the enriched cell to open the Cell Details panel • Look for the specific endpoints you want to display • Click "Add as column" next to each desired endpoint 2. Check if you've enabled the correct data fields: • In the enrichment configuration panel, verify that the relevant data fields are toggled on • Look for toggle switches next to fields like Emails, Type, Confidence, etc. • Enable the specific fields you want to display in your table If the columns are still empty after following these steps, you may need to map the enrichment endpoints to your existing columns or create new child columns to properly display the data.
Hey Hakiem! I'm seeing your rows 374-375 had empty values despite successful enrichment in your waterfall sequence. This typically happens when auto-update is turned off.
Was your table set to auto-update off when you ran these enrichments? The system wouldn't automatically populate values from successful enrichments when auto-update is disabled, which would explain why rerunning works but costs you extra.
Let me know if you're still experiencing issues with the enrichment flow even with auto-update enabled.
Hey Hakiem, I'm having a hard time replicating this issue on my end. It's not behaving like you mentioned when I try it.
Could you record a video showing how this happens? Are you able to replicate it right now?
.png){kind=logo}
