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.