Modify joins within a worksheet

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.

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:

  1. Click the Data tab in the top menu.

  2. Under Data Objects, select Worksheets.

  3. Click the name of the Worksheet. Here, we selected the worksheet West Regional Sales.

  4. At the top of the Worksheet, click Joins.

  5. 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.

      worksheet join schema view

      Note the available actions for the join view.

      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.

  6. Select the join you plan to modify, and click the Edit (pencil) icon next to it.

  7. In the Edit Join window modal, make the necessary changes:

    change join
    • 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.

    Click Save.