Merged Connection

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

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.

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

Please Note:

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

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

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

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

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

Last updated