Show TOC

Unifying Data from Two Data Sources (Union)Locate this document in the navigation structure


You use this transformation to unify two data sources (database operation Union All).

The two data sources do not have to have the same structure. The result structure automatically includes all fields of the data sources. Fields with the same name must, however, have the same data type in order for the data of both data sources to be added to the same result column.


For the transformation Unify Data from Two Data Sources (Union), you do not make any settings. You can influence the result structure by adjusting the structures of the two data sources in preceding transformations. If you want fields with different names to be added to the same column in the union results, rename these fields using the Projection transformation.

Identical data records are not removed. If required, use the Restrict Dataset transformation as a subsequent step to aggregate the data by using selected group fields.

A field that occurs in a data source only is filled with the initial value in all data records from the other data source.


You want to unify business partner data from an InfoProvider with additional data for these and other business partners from an external source.

You do not want to process the intersection of the data of the InfoProvider and the additional source (join); you want to process all data from the business partners from data sources 1 and 2.