Relationships

Although this chapter will primarily focus on joins, blends, and manipulation of data structures, let's begin with an introduction to relationships: a new functionality since Tableau 2020.2, and one that the Tableau community has been waiting for a long time. It is the new default option in the data canvas; therefore, we will first look into relationships, which belong on the logical layer of the data model, before diving deeper into the join and union functionalities that operate on the physical layer.

To read all about the physical and logical layers of Tableau's data model, visit the Tableau help pages: https://help.tableau.com/current/online/en-us/datasource_datamodel.htm.

For now, you can think of the logical layer as more generic, where the specifics are dependent on each view, whereas the physical layer dives deeper, starting from the data source pane.

In the following screenshot, you can see the data source canvas, with two...