XMPro Union Transformation Agent – Data Integration Guide

Combine multiple datasets into a single result set with the XMPro Union Transformation Agent. Supports two or three data inputs.

Overview

A union combines multiple data sets into a single result set. Columns should have the same name and compatible data types in all input data sets.

When using a strict combine, only columns common across all input data sets are combined.

When using a full combine (null-padded), a column that is not present in all input data sets will be filled with null.

Regardless of the type of union, ensure that columns with the same name have a compatible data type.

Fig 1: Strict Combine Example

The XMPro Union Transformation Agent merges two or three data inputs in a Data Stream, aligning columns with matching names and compatible types. Use this agent to streamline data integration and reporting in your XMPro data streams.

For a simple use case, see the Union Transformation Agent Example.

For a detailed configuration guide, see the Union Transformation Agent Configuration.

Unlike the SQL Union operation, the XMPro Union will not fail if the source payloads differ - however columns that are not present in all source datasets are ignored

Current Version

• Download the Union Transformation v1.08 (Last Updated: 27 May 2025)

• Additional Prerequisites: None

Please contact XMPro if you're looking for an older version of this agent.

Union Release Notes

Version	Date	Description
1.08	27 May 2025	Repackaged to translate the Agent's properties. Added "Columns to Return" to simplify configuration when the incoming payloads differ. Opt to fill with nulls rather than a strict combine. Added an Error Endpoint.
1.06	07 Sep 2022	Repackaged to include the Agent's Category.
1.05	05 Mar 2019	Updated help URL.
1.04	31 Jul 2018	Initial Release.