Unify Data from Two Data Sources (Union) 

Use

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 so that the system can add the data of both data sources to the same result column.

Activities

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 only occurs in one data source is filled with the initial value in all data records from the other data source.

Example

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.