Clay S. Most of my emails from enrichment are populating in the far right column, but I'm seeing some waterfall enrichments successfully find emails, but not put them into the right column (attached) is this expected behavior?
Yes, this is expected behavior. When waterfall enrichments find emails but they don't appear in the final column, it usually means the emails were found by a data provider but failed the validation check. The final validated emails will appear in the last column of your table, while validation columns are hidden by default to keep your table tidy. You can unhide these validation columns to see exactly why certain emails make it to the final column while others don't - this will show you how the validation process is working. The waterfall continues running even after finding an email specifically because it needs to validate that email first.
Hi - Mark M. I noticed a small issue in the Clay table some of the waterfall enrichment steps are successfully finding emails, but they’re not appearing in the final “Personal Email” column. This is expected behavior when different enrichment steps return emails in separate columns and that data isn’t mapped correctly to the final output column. I'll create a Final Email formula column using the firstNotNull() function. This will pull the first valid email from all the enrichment steps, ensuring we always have a clean, consistent output. Let me know if you'd like me to set that up for you.
You're correct that this is expected behavior. When waterfall enrichments find emails but they don't appear in the final column, it usually means the emails were found by a data provider but failed the validation check. The final validated emails will appear in the last column of your table, while validation columns are hidden by default to keep your table tidy. You can unhide these validation columns to see exactly why certain emails make it to the final column while others don't. Your approach with the firstNotNull() function is a good solution for consolidating emails from multiple enrichment steps into one clean output column.
