Relationships
Relationships are a way to combine tables together on Tableau, side by side, on a common field(s). However, instead of creating a fixed large table that merges the two data sources, the tables are kept separate at their individual level of detail and joins are created automatically based on the fields used in the view.
Relationships are more flexible than joins as only the relationship (similar to a join clause) has to be configured. A join type does not need to be selected because what is included or excluded from the data depends on the fields used in the view. The fact that relationships keep tables distinct means no data is lost and that tables can be at different levels of aggregation because they are not physically joined, so there is no chance of data duplication. The aggregation of measures and the joins required are all calculated by Tableau; the user only needs to define the relationship that connects the tables.
To create a relationship in Tableau, drag...
