# Merged Connection

{% hint style="info" %}
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://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FmnwDrFeQl5iJ7jr6IzbL%2FMergeConnection.gif?alt=media&#x26;token=74d7241a-d258-4b42-aa66-8eb496f8c0ef" alt=""><figcaption></figcaption></figure>

* 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.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FLMZs2iLqR8XVjxWVMdho%2Fimage.png?alt=media\&token=22547a7f-58de-4684-b2e0-07aef9c5cf94)

<mark style="color:green;">Please Note:</mark>

* The users can remove the fields added to the merged data connection using the ***Remove***  icon.

&#x20;     ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FVXZT2MSdeIeVkbMYxU93%2Fimage.png?alt=media\&token=ea7fa826-b7b5-448a-9e5c-31203a10936b)

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

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FvnJJpNLCPsb3rKVDxas7%2Fimage.png?alt=media\&token=514e44f7-8422-4f6e-a731-9b7c5842748a)

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

### Creating a Calculated Field

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

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

&#x20;     ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FSOVcXIMmASb1dwD0VRls%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. &#x20;

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

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

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