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. Select 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, select 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.

      Image of the joins section of a worksheet. There is a 1 next to the joins within this worksheet/joins from this worksheet dropdown. There is a 2 next to the Edit icon for the join. There is a 3 next to the up arrow icon.

      Note the available actions for the join view.

      1.

      See either Join within this Worksheet (Default), or Joins from this Worksheet.

      2.

      Select the pencil icon to edit the join.

      3.

      Select 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:

    Joins within this worksheet with the edit icon highlighted. Edit join modal
    • 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.

  8. Select Save.