Append Queries

Use Append Query to combine rows from multiple queries into a single query. Append queries when the source tables have the same column structure and compatible data types.

Example scenario#

To illustrate how Append Query works, imagine a scenario where you store employee bonus data separately for the HR, IT, and Sales departments.

The following table shows sample employee bonus data for the HR department.

The following table shows employee bonus data for the IT department.

The following table shows employee bonus data for the Sales department.

Append the department data to create an organization-level view of employee bonuses. The following table shows the appended data from all departments.

Append queries#

The following example shows how to append regional sales queries into a single query.

1. Open the bridge that contains the queries you want to append.

   In this example, the bridge contains sales queries for Australia, Canada, France, United Kingdom, and the United States.
   

   

2. On the Data tab, select Append Query.
   

3. In the Append Query dialog, expand the Source field and select the queries that you want to append.

   Select only the queries that contain the data you want to combine. For example, if a bridge contains sales and budget queries, select only the relevant sales queries.
   

   

4. Verify the queries that appear in the Source field.
   

   

5. Select Apply.

   After the append operation completes, Infobridge creates a new query that contains the combined rows from the selected queries. Infobridge lists the source queries under Source Name, and the append operation appears in the Performed Steps pane.

   

Next, continue transforming the appended query as needed or write the data to a destination.