This article applies to the Admin Console > Data > Joins settings.
Joins specify to Exago the relationship between Data Objects.
All existing Joins are listed in the Main Menu under Data. All the joins you are adding or editing will be displayed in a tab entitled Joins.
Create, Edit, Delete Joins
- To add a new join click Joins in the Main Menu and either:
- click the Add icon at the top of the main menu
- right-click and select Add from the context menu
- or to quickly add data joins, use the Automatic Database Discovery tool
- To edit a join either:
- double click it
- select it and click the Edit icon at the top of the main menu
- right-click it and select Edit from the context menu
Review the Modifying Joins section below when making changes to joins in the Admin Console.
- To delete a join either:
- select it and click the Delete icon at the top of the main menu
- right-click it and select Delete from the context menu
- To save changes and new joins click the Apply or Okay buttons.
Every join has the following properties:
The first Data Object you would like to join.
The other Data Object you would like to join.
- The order of the Data Objects is important if you have a one-to-many relation type or a Left/Right Outer Join type. See below for details.
Specify the field(s) of each Data Object that must match to join an entity in the From Object to an entity(s) in the To Object.
Specify whether rows from either Data Object that do not have a match should or should not be included.
- Inner: only includes rows of the From Object that have a match in the To Object and vice versa.
- Left Outer: includes rows of the From Object that do not have a match in the To Object but not vice versa.
- Right Outer: includes rows of the To Object that do not have a match in the From Object but not vice versa.
- Full Outer: includes rows in either Data Object that do not have a match.
Specify if the join type is one-to-one or one-to-many.
- One-to-One: Each row in the 'From Object' can join to at most one row from the 'To Object'.
- One-to-Many: Each row in the 'From Object' can join to any number of rows from the 'To Object'.
Give a join weight in order to set its precedence when multiple join paths exist between Data Objects. The path with the higher weight will be utilized.
- A report contains three Data Objects ‘Students’, ‘Professors’ and ‘Comp Sci 101.’ Students is joined to ‘Professors’ and ‘Comp Sci 101.’ Additionally ‘Professors’ is joined to ‘Comp Sci 101.’ There are two available join paths between ‘Students’ and ‘Comp Sci 101.’ Adding weight to a join will clarify which of the two paths Exago should use.
Although joins are created in the Administration Console, they are saved within each individual report. For Join changes in the Administration Console to take effect, edit the report and use the ‘Recreate’ button in the Advanced Options menu. For instructions on how to access the Advanced Options please see Advanced Report Designer: Advanced Options.
It is important to make sure that all of the joins are set to your desired specifications in the Administration Console before you begin building numerous reports.
Note About Cross Source Joins
Data Objects from different Data Sources can be joined in Exago. Because the Data Objects come from distinct data sources they must be joined through code by Exago.
Though Exago strives for efficiency, this process may be memory intensive for large data sets.