Append

You can have data sourced from multiple systems that need to be unified into a single table. Consider the employee bonus data from different departments:

We need to combine the department-wise data to get an organizational level view of the bonus allocated to each department. The Append function is used in such scenarios where the structure (data type and number of columns) of all the source tables is exactly the same. The table below shows the appended data from all departments.

We'll look at how to append data in Infobridge. The SALES bridge has regional sales from multiple countries.

Click on Append Query. We'll be able to select the queries to combine. You may have sales and budgets in the same bridge, in which case you need to select only the queries that need to be appended.

The selected queries will be displayed in the Append dialog box. We can click Apply.

The consolidated data is stored in a new query that can either be written back or cascaded to a target report.