Joins

The Incorta Unified Data Analytics Platform allows you to join two tables in separate schemas, even if the source data exists in two separate databases. Joins can be viewed from within a Parent schema table. For example, If schemaA.Table1 is joined to schemaB.Table2 (where Table1 is the child table while Table2 is the parent table), then the join can be viewed in the schema where the parent table is, i.e. schemaB.

Create a join from the schema definition page

1. Select + New in the upper right-hand corner of the screen and select “Join” from the drop-down menu.

2. Select the parent and child tables, along with the join type, in the appropriate fields. You can also add filters by clicking + in the upper right-hand corner of the “Filters” block.

Create a join from the table details page

1. Locate the table of interest and select it.

2. Select + New in the upper right-hand corner of the screen.

3. Select a parent/child join from the drop-down menu.

4. To add conditions to any join, select “Join Details” in the drop-down menu in the upper right-hand corner of the block of that join. To delete a join, select “Remove Join”.

5. Add filters to a join by clicking + in the upper right-hand corner of then filter block.

Modify an Existing Join

To modify an existing join:

1. Select the down arrow in the upper right-hand corner of the join.

2. Select “Join Details” to modify the join conditions.

3. Select + in the filter box to add filters for the join.

Delete a Join

To delete a join, select the corresponding down arrow, and select “Remove Join”.