> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/governed-dashboards-5/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/governed-dashboards-5/connecting-to-a-data-source/establishing-a-data-connection/merged-connection.md).

# Merged Connection

Steps to develop a data connection based on the Merged data.

{% hint style="success" %}
*Check out the given walk-through on how to create a data connection based on the multiple merged connections and associate it to a charting component.*
{% endhint %}

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FmAthdONygcMwZ70DUADE%2FMergeConnection.gif?alt=media&#x26;token=74d7241a-d258-4b42-aa66-8eb496f8c0ef" alt=""><figcaption></figcaption></figure>

## Merging Data Fields  <a href="#merging-data-fields" id="merging-data-fields"></a>

* Click the **Data Connectors** icon.
* Create new connections using any data connector option (In this case, Excel connections are created. E.g., Connection-1, Connection-2).
* Create a connection under the ***Merged Data*** connector. (E.g., Connection-3).
* Configure the new connection created for Merged data by mapping the created Excel connections.
* Define a condition via the drop-down menu in the Criteria space. (E.g. ***Equal*** or ***Not Equal***)
* Click the ***Create Criteria*** icon.
* The Merged Fields displays all the data fields from the merged connections.

<figure><img src="https://content.gitbook.com/content/nyOeUTaPuBluyvesHVm9/blobs/T91cgxbZqh0IRS5F3WtP/image.png" alt=""><figcaption></figcaption></figure>

* After clicking the ***Create Criteria*** icon, the created criteria get added to space.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FaAN7zuSG7mgKaM2IutCF%2Fimage.png?alt=media&#x26;token=514e44f7-8422-4f6e-a731-9b7c5842748a" alt=""><figcaption></figcaption></figure>

* Trigger a script to produce some action on the connection part using the ***Script on Load*** icon.

## Removing fields from the Merged Data Connection <a href="#removing-fields-from-the-merged-data-connection" id="removing-fields-from-the-merged-data-connection"></a>

*The users can remove the fields added to the merged data connection using the **Remove** icon.​*![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F4CNhVNNQSR6QHo2bf1RC%2Fimage.png?alt=media\&token=8f0005f8-7654-475a-ac5f-ba3cb92f3142)*​*

## Creating a Calculated Field <a href="#creating-a-calculated-field" id="creating-a-calculated-field"></a>

Select the ***Calculated Fields*** tab to access Calculated Field Editor and add the calculated fields.

* Click the ***Calculated Fields*** tab.
* Click the ***Add*** icon.

![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FdJ5LqyBxyUcKtQoblAen%2Fimage.png?alt=media\&token=9393f4c4-4889-4d18-a44b-8b2611cbe228)​

* The Calculated Field Editor window opens.
* Provide a title for the calculated field.
* Insert calculation formula inside the Script Editor space.
* Click the ***Create*** option.

![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FgjstrLUdJ18q5oBRwYJd%2Fimage.png?alt=media\&token=2d233773-bb64-4ba7-8c48-03b855dbd5bb)

* The newly created Calculated field gets added under the ***Calculated Fields*** tab.

![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F9JAHja4QHl8SpB0RGu80%2Fimage.png?alt=media\&token=9b6dc7e7-1476-4dc1-81e8-a475baedce56)​