Editing Join Details

Occasionally, it becomes necessary to change the specifications of existing table joins.

The following steps demonstrate how to change join detail.

1. Navigate to the Data Model page of the dataset.

2. Click Edit Data Model to edit the data model.

   

3. Click the (link) icon that represents the connection that must be changed, and after the Join Details modal window appears, click Edit Join Details.

   

4. In the Edit Join modal window, make the necessary adjustments.

   1. [Optional] Click Clear Fields to clear all already defined joins between the two tables.
   2. [Optional] Click Add Join Pair to add another column connection between the same two tables.
   3. [Optional] Click icon (minus) next to an existing join definition to remove that column connection between the two tables.
   4. [Optional] Click Add Join Expression to add a conditional join between the same two tables.
   5. [Optional] Click icon (minus) next to an existing join expression to remove that column connection between the two tables (not illustrated.
   6. [Optional] Click sample data to preview the data. Click again to hide sample data.
   7. Click Apply.

   

5. [Optional] To revert all changes prior to saving, click Undo.
6. Click Save.