Consolidating Email Results from Multiple Providers in a Waterfall

Automatic Consolidation

Email waterfalls automatically populate a final result column with successful emails from any provider. The individual provider columns feed their data into one unified result column.

For setup details, see Enrich Companies Waterfalls - Automated Outbound.

Creating a Final Email Column

If the final result column isn't visible, create it manually:

1. Click on a cell containing a found email from any provider column
2. In the Cell details panel, hover over the email field and click "Add as column"
3. Name the new column "Final Email" or similar

Optimizing Your View

Configure your waterfall to:

• Display the final results column
• Hide individual provider columns for a cleaner interface

For configuration details, see Building a Data Waterfall.

For more on column management, see Table Columns Overview.

This approach eliminates manual copy/pasting between provider outputs.

NULL

The original answer describes a problem (results from specific providers being isolated when adding a column) but does not provide any solution or actionable guidance on how to consolidate email results from multiple providers in a waterfall. It identifies an issue rather than answering the question asked.

Consolidating Email Results from Multiple Providers in a Waterfall

To combine email results from multiple providers into a single unified column:

1. Click Add column → Merge columns
2. Select "Text" as the data type
3. Write a formula using / to include all your email provider columns
4. The merge column will automatically check each column in sequence and return the first valid email found

This approach ensures you capture successful results from any provider without missing data.

Reference:

• Table Columns Overview
• [Enrich People Waterfalls - Automated Outbound](https://www.clay.com/university/lesson/enrich-people-waterfalls-automated-outbound?8913605e_page=