Why Join ?

When an object (a Table, a View, etc…) is already present in the Data Source and you want to add another object, you will have to specify how the two objects will be merged together to create a single data query.

In order to do this, a database JOIN operation is used.

This operation can be very useful for adding context to your data :

  • your Table1 contains physical measurements
  • your Table2 contains context information like where was data measured, what product you were producing at that time, etc…
    ⇒ This is all multiple aspects of the same information. By joining, you will be able to present all this data consistently in your visualizations.

What can I join ?

Joins can be created across all Connections, all Connection types (SQL, Excel, Historian, …), all object types (Tables, Views, Stored Procedures, …).
Any Number of join conditions can be created.

How to Join tables

When an object (a Table, a View, etc…) is already present in the Data Source and you add another object, the Join Editor dialog automatically opens to let you configure the join relationship.

If you cancel this dialog, the new object is not added.

Last modified: Sep 13, 2021

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment