Editing Join Details

The following steps demonstrate how to change join detail.

1. On the Data Data Model page, click Edit Table Links to edit the data model.

   

2. Click the icon (link) that represents the connection that must be changed, and after the Column Connections modal window appears, click Edit Join Detail.

   

3. In the Edit Column Connections 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 view some data in the Source Column and/or Target Column. Click again to hide sample data.
   7. Click Apply.

   

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