Learn how to change the join type between the tables within a worksheet

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.

Beginning in ThoughtSpot version 5.0, you aren’t 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.

To modify the join types within a worksheet:

  1. To find your worksheet, click Data in the top menu, and choose Worksheets.

  2. Click the name of your worksheet.

  3. Click Schema. You will see the list showing existing joins within the worksheet. The joins shown here include all the joins between the underlying tables, whether created using TQL or in the browser.

    If you don’t see the joins within the worksheet, make sure Joins within worksheets is chosen.

  4. Find the join you want to modify and click the Edit icon. Note that the fact table is always the left table, and it is shown on the left side.

  5. Select the join type to use for this relationship in the worksheet and click Save.

Now these two tables will be joined using the type you selected, in the context of this worksheet.