Creating Joins

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.

*What is a join ?
In simple terms, a join between a data Table1 and a Table2 expresses how an entry in Table1 describes the same information as another entry in Table2.
“Joining” comes from SQL terminology. If you know SQL, this editor should expose familiar concepts.

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.

*Note : Multi-Connection
When a Data Source joins tables from at least 2 different Alpana Connections, the Connections become bufferized.

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.