When you create a worksheet, you select a join rule. The join rule works together with the joins defined within the worksheet determine how the tables that make up the worksheet are joined, and how those joins behave when searching on the worksheet.
Starting with ThoughtSpot version 5.0, you are not limited to just one join rule for the entire worksheet. You can define different types of joins for each join between tables in a worksheet. Be default, each of these individual table joins uses an inner join. But you can override this at the individual join level.
You must have either the Can administer ThoughtSpot privilege or the Can manage data privilege to modify joins within worksheets.
Modify a join
To modify the join types within a worksheet, follow these steps:
Click the Data tab in the top menu.
Under Data Objects, select Worksheets.
Click the name of the Worksheet. Here, we selected the worksheet West Regional Sales.
At the top of the Worksheet, click Joins.
- The join information and the schema for the worksheet appear.
- The schema representation includes the join type.
- You can see the list of Joins within the worksheet, which include all joins between the underlying tables, both created using TQL and created in the browser.
- The fact table is always on the left side of the join, and it appears on the left side.
Note the available actions for the join view.
Legend Action 1. See either Join within this Worksheet (Default), or Joins from this Worksheet. 2. Click the pencil icon to edit the join. 3. Click the up arrow icon to collapse the join detail.
Select the join you plan to modify, and click the Edit (pencil) icon next to it.
In the Edit Join window modal, make the necessary changes:
- Under Join Type, select one of Inner Join, Left Outer Join, Right Outer Join, or Full Outer Join.
- Under Join Cardinality, select either Many to One, or One to One.