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.
.png?alt=media&token=deba77dd-5037-4b4b-9b10-87bdf6e78b6e)
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
Name | Link |
---|---|
Union Transformation v1.06 |
Last modified 1yr ago