Union All of Multiple Data Tables

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:

• Performance data to its benchmark.
• 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.

   

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support