# 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:

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F0C29p9s7flp5TSRvZZI3%2Fimage.png?alt=media&#x26;token=03819ab1-076a-471c-9a19-06979fb3d2d2" alt=""><figcaption><p>HR department</p></figcaption></figure>

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FuUj8BIIM0udRc8fXAXt9%2Fimage.png?alt=media&#x26;token=3755528b-7c5c-4c71-baad-ed7494ac6352" alt=""><figcaption><p>IT department</p></figcaption></figure>

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FKoWm0cWOgm0i6KFAxk8Q%2Fimage.png?alt=media&#x26;token=f889f1ab-275c-451f-8568-ec23535737d4" alt=""><figcaption><p>Sales and marketing department</p></figcaption></figure>

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.&#x20;

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F7hhSwcMpIfQ6nipdAsXE%2Fimage.png?alt=media&#x26;token=77b4bca2-f1dc-4714-b9e6-8d66f37a711e" alt=""><figcaption><p>Appended data</p></figcaption></figure>

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

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fgs8ph6kzxGtY79lnXjuY%2Fimage.png?alt=media&#x26;token=3e802ac0-158b-4630-aa27-a90066d3b6de" alt=""><figcaption><p>Sales bridge with sales across different regions</p></figcaption></figure>

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.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FlKDCbVm0Yk3IYYkG70Lu%2Fimage.png?alt=media&#x26;token=226e1723-0846-4ef5-ae67-367b7c585704" alt=""><figcaption><p>Selecting queries to append</p></figcaption></figure>

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

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F5RwQFhYguJaLFUSGNMt5%2Fimage.png?alt=media&#x26;token=b599dbd3-5b9c-4e57-9dd2-809a974f8464" alt=""><figcaption><p>Append query dialog box</p></figcaption></figure>

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

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F5CRRRCa5GpisBd4mtmil%2Fimage.png?alt=media&#x26;token=f8d8d828-6f38-4736-80d6-94180586cd0c" alt=""><figcaption><p>Appended data</p></figcaption></figure>
