Concatenate Column
Infoveave Data Automation — Text & String
Pick the columns, set the separator, name the output — two or more fields become one clean combined value on every run.
Reports, dashboards, exports, and downstream systems frequently need composite values that do not exist as a single field in the source dataset. Employee display names combining ID and name, full addresses combining street, city, and country, or composite join keys combining region and product category are all common requirements. Concatenate Column builds these combined values automatically — select the source columns, set the separator, and name the output column. The combined column is added to the dataset on every workflow run without any formula authoring or manual column creation.
What Concatenate Column does
Merge values from two or more columns into a single combined column in Infoveave. Create composite keys, display labels, and formatted identifiers from existing fields with a configurable separator.
When to use Concatenate Column
- You need to create a composite key by combining two or more columns — for example joining a RegionCode and a ProductCategory as a single join key for a multi-dimensional lookup
- You want to add a display-friendly label to the dataset by combining ID and name columns for use in dropdown menus, exports, or report dimensions
- You are assembling a formatted output field — such as a full mailing address, a structured display identifier, or a combined subject line — from multiple source columns
- A downstream system or BI tool expects a single column that combines data from multiple source fields that are stored separately in your source system
When to avoid it
- You want to split an existing combined column into its component parts — use Split Column (by delimiter) or Split Email Address, Split URL, or Split HTTP Query for specific structured formats
- You need to derive a calculated numeric or date value from multiple columns — use a Calculated Column for arithmetic or date expressions rather than string concatenation
- The values you want to combine are array-type columns rather than scalar string columns — use Concatenate Array for merging array-valued columns
Where it fits in your Infoveave automation
Concatenate Column is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Concatenate Column
Real scenarios where this transformation saves hours of manual work.
Build Product Display Labels for Dashboard Dimensions
A retail analytics team needs a single display label for each product in their dashboard that shows both the SKU and the product name — for example P001 - Wireless Mouse — to use as readable dimension labels in charts and filters. Concatenate Column combines the product_id and product_name columns with a separator of dash-space, producing a new display_label column that appears in dropdown filters and chart tooltips without requiring users to mentally map SKU codes to product names.
Create Composite Employee Identifiers for System Exports
An HR team exports employee records to a payroll system that requires a composite employee reference key combining department code and employee ID — such as SALES-E001. Concatenate Column combines the department_code and employee_id columns with a hyphen separator, producing the required composite key as a new column that is included in the export file. The key is generated automatically on every scheduled payroll export run.
Assemble Full Transaction Descriptions for Audit Reporting
A financial audit team needs a single description field in their audit report combining the transaction date, amount, and merchant name columns into a human-readable description — for example 2025-01-15 | USD 1200.50 | Amazon. Concatenate Column builds this combined description automatically on each audit export run by combining the three columns with a pipe separator, producing a single audit description column without manual spreadsheet formula work.
See Concatenate Column in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
employee_id, nameEmp_info, (comma-space)EnabledInput Data
| employee_id | name | age | department | role |
|---|---|---|---|---|
| E001 | John Doe | 32 | Sales | Sales Manager |
| E002 | Jane Smith | 28 | Engineering | Software Developer |
| E003 | Ali Khan | 40 | Finance | Financial Analyst |
Output Data
| employee_id | name | age | department | role | Emp_info |
|---|---|---|---|---|---|
| E001 | John Doe | 32 | Sales | Sales Manager | E001, John Doe |
| E002 | Jane Smith | 28 | Engineering | Software Developer | E002, Jane Smith |
| E003 | Ali Khan | 40 | Finance | Financial Analyst | E003, Ali Khan |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Input Columns
Select two or more columns whose values will be joined together. The columns are concatenated in the order you select them. You can combine text and numeric columns — numeric values are converted to their string representation before concatenation.
Separator
The character or string placed between each combined value. Common choices are a comma, hyphen, pipe, space, or underscore. The separator appears between every pair of combined values — for three columns A, B, and C with a hyphen separator, the output is A-B-C. Set the separator to an empty string to concatenate with no delimiter between values.
Include Original
When enabled, all selected input columns are retained alongside the new combined output column. When disabled, only the output column is present in the result. Retaining originals is useful when downstream steps still need the individual source fields alongside the combined label.
Frequently asked questions
Everything you need to know about Concatenate Column in Infoveave.
Also in Text & String — and what runs before & after
Transformations in the same family as Concatenate Column, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Concatenate Column is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
