MCP ServerMerge 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.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 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
Add a Merge Columns transformation
Open your table, add a new transformation column, and select Merge Columns.
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.
Example
Suppose you have three columns for company website:| Website (Apollo) | Website (Clearbit) | Website (Import) |
|---|---|---|
| - | acme.com | acme.io |
| globex.com | - | globex.net |
| Merged Website |
|---|
| acme.com |
| globex.com |
Related
Tables overview
Learn how tables work in Databar.
Excel formulas
Use formulas for more complex merging logic.