Union

​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
Pre-requisites
None at this time
Download
Name
Link
Union Transformation v1.06
​Download​
Please contact XMPro if you're looking for an older version of this agent.

Name	Link
Union Transformation v1.06	Download

Next - How to use?

Example

Last modified 6mo ago