There are occasions where the source data is held across multiple disparate repositories so that the rows of the data set are distributed. In this case, instead of doing a Join, perform a Union All.
Common use cases for union all include:
q Performance data to its benchmark
q Historical data from a database to current streaming data from a message bus
Union All is done based on column position and requires data type match between data sources.
1. To join the data sources, click the Join button.
The Join Settings pane displays.
2. Select Union All then click .
The result of the union all is displayed in the Data Source Preview.
3. Click . Once saved, a notification displays.