Append

In the module, we'll explore how to use append functions to combine data with the same structure from multiple tables.

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:

HR department

IT department

Sales and marketing department

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.

Appended data

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

Sales bridge with sales across different regions

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.

Selecting queries to append

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

Append query dialog box

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

Appended data