Skip to main content

Overview

Multi-field mapping allows you to combine or transform data from multiple source fields into a single entity field. Entegrata provides powerful operators that handle common data combination scenarios without requiring code. This guide covers all multi-field operators and how to use them effectively in your data pipelines.
Required permissions
  • Data Pipelines: Access
  • Manage Silver Entities or Manage Gold Entities, for the layer: Update
  • Manage Production Pipelines (for production pipelines and the main pipeline) or Manage Dev Pipelines (for development pipelines): Update
Creating or changing a multi-field mapping needs Update on both the layer and the pipeline. A role can limit pipeline Update to specific pipelines. See roles and permissions and permission dependencies.

Available Operators

Operator Overview

Operator selection menu

COALESCE Operator

What is COALESCE?

COALESCE returns the first non-null value from a list of fields. It’s perfect for providing fallback values when preferred data might be missing. Syntax: COALESCE(field1, field2, field3, ..., defaultValue)

Common Use Cases

Email Address Fallback:
Phone Number Fallback:
Name Fallback:

Creating a COALESCE Transformation

1

Connect Multiple Input Fields

Drag a second source field to an entity field that is already mapped. This automatically creates a logic node on the canvas, defaulting to a Use First Available (Coalesce) operation. Alternatively, click the entity field to open the Edit Field modal and configure the operator on the Data Source tab.
2

Verify Field Priority Order

The order matters - COALESCE checks fields left to right. You can view and change the order of the inputs by dragging the fields listed in the Field Priority Order section.
View and re-order source fields
3

Set Default Value (Optional)

Check the Default Value checkbox and enter a fallback value to use if all input fields are null.

COALESCE Best Practices

Ordering Inputs
  • Put most reliable/preferred fields first
  • Put default or fallback fields last
  • Consider data quality when ordering
If all fields are null and no default is provided, the entity field will be null. For required fields, always provide a default value.

CONCAT Operator

What is CONCAT?

CONCAT combines multiple text values into a single string. You can add separators, prefixes, and suffixes. Syntax: CONCAT(field1, separator, field2, separator, field3, ...)

Common Use Cases

Full Name:
Full Address:
Composite Key:
Email Construction:

Creating a CONCAT Transformation

1

Connect Multiple Input Fields

Drag a second source field to an entity field that is already mapped. This automatically creates a logic node on the canvas, defaulting to a Use First Available (Coalesce) operation. Alternatively, click the entity field to open the Edit Field modal and configure the operator on the Data Source tab.
2

Select Concat Combination Option

In the Edit Field modal’s Data Source tab, select Join Text (Concat) from the Operator dropdown.
Select the CONCAT option in the dropdown
3

Verify Text Combination Order

The order matters - CONCAT appends fields left to right. You can view and change the order of the inputs by dragging the fields listed in the Text Combination Order section.
View and re-order source fields
4

Configure Text Separator

In the Text Separator field, enter the character(s) to insert between each field value (e.g., a space, comma, or dash).

CASE Operator

What is CASE?

CASE provides if-then-else conditional logic. Transform values, categorize data, or apply complex business rules based on conditions. Syntax:

Common Use Cases

Status Categorization:
Value Ranges:
Boolean Conversion:
Multiple Conditions:

Creating a CASE Transformation

1

Connect Multiple Input Fields

Drag a second source field to an entity field that is already mapped. This automatically creates a logic node on the canvas, defaulting to a Use First Available (Coalesce) operation. Alternatively, click the entity field to open the Edit Field modal and configure the operator on the Data Source tab.
2

Select CASE Combination Option

In the Edit Field modal’s Data Source tab, select Apply Conditions from the Operator dropdown.
Select the CASE option in the dropdown
3

Build First Condition

In the Edit Field modal’s Data Source tab, click Add case to create a new condition:
  • When: Define the condition to evaluate (field, operator, and value)
  • Then: Specify the output value when the condition is true
  • Check Default Case (ELSE) to set a fallback value when no conditions match
First CASE condition configuration
4

Add More Cases

Click Add case to add additional conditions. Cases are evaluated in order from top to bottom.
5

Set Default Case

Check Default Case (ELSE) at the bottom and enter the fallback value returned when no conditions match.
Always provide a default case, especially for required fields. Without it, unmatched records will be null.

Available Operators in CASE

CASE Best Practices

Condition Ordering
  • Put most specific conditions first
  • More general conditions go later
  • Always include an ELSE clause

Troubleshooting

COALESCE Returns Unexpected Nulls

Issue: COALESCE still returns null even with multiple input fields. Solutions:
  • Verify input field order
  • Check that at least one input has non-null values
  • Add a literal default value as last input
  • Check each input field separately

CONCAT Produces Extra Separators

Issue: Concatenated string has separators where fields were null. Solutions:
  • Enable “Skip nulls” option in CONCAT settings
  • Use COALESCE on inputs to convert nulls to empty strings
  • Consider using CASE to handle null scenarios differently

CASE Always Returns ELSE Value

Issue: No conditions seem to match. Solutions:
  • Verify field data types match comparison values
  • Check for whitespace in string comparisons
  • Use case-insensitive operators for text
  • Check the actual values in your source system
  • Check operator choice (= vs CONTAINS vs STARTS WITH)

Mapping Fields

Learn basic field-to-field mapping

Field Management

Configure entity field properties and data types

Default Values

Set default values for fields

Data Mapping Editor

Complete guide to the mapping editor interface