# 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://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(43).png" alt=""><figcaption><p>HR department</p></figcaption></figure>

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(44).png" alt=""><figcaption><p>IT department</p></figcaption></figure>

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(45).png" 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.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(46).png" 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://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(47).png" 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://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(49).png" 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://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(50).png" 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://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(51).png" alt=""><figcaption><p>Appended data</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/infobridge/how-tos/4.-manage-queries/query-transformations/append.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
