Changing Join Types

This article demonstrates how to change the join type in a table.

The following steps demonstrate how to change the join type in the airport_codes table from the default Left join to the Right join.

  1. Navigate to the Data Model page of the dataset.

  2. Click Edit Data Model to edit the data model.

    Editing Table Links
    Editing Data Model
  3. Click the (link) icon that represents the connection that must be changed.

    In our example, we clicked the join with the table airport_codes.

    Editing a table join
    Editing Table Joins
  4. The Join Details modal window appears.
  5. In the Join Details modal window, select an alternate join type.

    For example, instead of the default Left join, select Right join.

    Changing join from Left-join to Right-join
    Changing Join Type from Left Join to Right Join
  6. Click outside the Join Details modal window. Or click Edit Join Details.

  7. Click Save.