Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.databar.ai/llms.txt

Use this file to discover all available pages before exploring further.

Merge Columns lets you combine multiple columns into a single output column using priority-based fallback logic. Databar picks the first non-empty value from your ordered list of source columns, giving you a clean, consolidated result.
Merge Columns is a transformation — it does not consume any credits.

​
When to use

When the same data point exists across multiple columns — often because you enriched from different providers — you end up with fragmented values. For example, you might have a company name from Apollo, another from Clearbit, and a third from your CRM import. Merge Columns resolves this into one authoritative column.

​
How to use

1

Add a Merge Columns transformation

Open your table, add a new transformation column, and select Merge Columns.
2

Select columns in priority order

Choose the columns you want to merge. The order matters — Databar will use the first non-empty value it finds, working from top to bottom.
3

View the result

A new column appears with the best available value for each row.
Merge columns configuration with priority ordering

​
Example

Suppose you have three columns for company website:
Website (Apollo)Website (Clearbit)Website (Import)
—acme.comacme.io
globex.com—globex.net
With Merge Columns set to priority order Apollo → Clearbit → Import, the result column would contain:
Merged Website
acme.com
globex.com
The first non-empty value wins.

Tables overview

Learn how tables work in Databar.

Excel formulas

Use formulas for more complex merging logic.