Join Tables

Once a table has been added to the data model, it can be linked to other tables to define relationships. You can join tables based on one or more matching fields.

You cannot join from a fact table. You cannot join a table that is already joined with another table.

note

Make sure the Design Graph is visible by hovering over View and selecting Design Graph.

Link tables

Join type	Description
Manually	Create joins between fields by dragging from one table to another in the Design Graph.
Suggested tables	Add joins from a dynamically generated list based on joins created manually by an administrator or joins provided in templates. The list updates automatically when new joins are available.
On specific tables	Add joins that match a field against a predefined constant, global parameter (##), or global variable (@@). Use this to link tables when values must match a specific code or dimension rather than another table field.

Join tables manually

1. In the Design Graph, select the two tables you want to join.
2. Expand each table using the icon in the top right corner.
3. Click and hold the field in the first table.
4. Drag the field onto the matching field in the second table.
5. Repeat the process for any additional fields you want to join.
6. On the File tab, click Save Data Model.

Join suggested tables

1. In the Design Graph, right-click a table header.
2. Select Suggested Joins.
3. Select the required joins and click + Add selected joins. The joins are created automatically, and any referenced tables or views are added to the Design Graph.
4. On the File tab, click Save Data Model.

tip

Use Delete Selected Joins to remove unwanted suggested joins.

Join tables on specific values

1. In the Design Graph, right-click a table header.
2. Select Joins on specific values.
3. Click Add a Join.
4. In From field, select the source field.
5. In Operator, choose the appropriate comparison operator.
6. In Value, enter a value in single quotes (for example, 'COMP001'), or select a global paramater (##) or global variable (@@).
7. (Optional) Repeat the process for additional joins.
8. Click Ok.
9. On the File tab, click Save Data Model.

Change the join type

1. In the Design Graph, right-click the arrow representing the join between two tables.
2. Select a join option between Left Join andInner Join.
3. On the File tab, click Save Data Model.

Delete a join

1. In the Design Graph, right-click the arrow representing the join.
2. Select Remove Join.
3. In the confirmation dialog, click Ok.
4. On the File tab, click Save Data Model.