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.

Only columns common across all input data sets are combined. If a column is not present in all input data sets and you want it included in the result, add a column with null values to the input data sets which do not contain it.

XMPro provides a convenient Transformation that can be used to perform a union operation on two or three data inputs in a Data Stream.

Details for an example and its configuration can be found in the How to Use section.

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


None at this time


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

Last updated