Steps: Set Up Union Tables

Union tables let you combine or stack table row data, even when the tables comes from different data sources. With a union, you combine rows from one table with rows from another table to make a single larger table. The data in each column must be of the same data type. For example, a retail chain that uses different ERP systems across regions may want to combine all ERP data into in a single large table.

Required Permissions: Integration and Data Designer

Verify you imported at least two staging tables for a data source.

Navigation

Basic Steps (optional)

Select data source tables.

Select data source table columns.

Select Data Source Tables

Select Custom Table
in the Data Component pane for a data source.

Drag and drop Union Table
into Tables to Import
(the staging area).

Enter a name for the Union table.

Select the Tables
tab.

Select the +
button to add a table to your union.

Click (Select)
in the TABLE
column to expand the list of available data sources and select a table.

(Optional) Select (Empty)
in the FILTER
column to launch a popup and write an SQL expression to filter the columns from this table. Click each Available Column you want to add to your SQL expression. Click online help
to view the SQL Expression Reference for all of the functions and operators you can use.

Repeat the three previous steps until you add all of the tables you want contributing to your union.

Select Data Source Table Columns

Select the Columns
tab.

Select the +
button and choose a data type for the table columns you want to union. Each of the data source tables you select shows up as a column header in the grid.

Click (Select)
under each of the column headers to choose a column from each table.

Repeat the two previous steps until you select all of the data source table columns you want participating in the union.

(Optional) Click a column name to rename it.

Select OK
to save your union table settings and view the results of your union.

Save the data source.