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.
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