Join types in Tableau
There are four types of joins usually used the most that wwe can use to combine the data in Tableau: inner, left, right, and full outer.
Join Type | Result | Description |
Inner |
When you use an inner join to combine tables, the result is a table that contains values that have matches in both tables.
| |
Left |
When you use a left join to combine tables, the result is a table that contains all values from the left table and corresponding matches from the right table.
When a value in the left table doesn't have a corresponding match in the right table, you see a null value in the data grid.
| |
Right |
When you use a right join to combine tables, the result is a table that contains all values from the right table and corresponding matches from the left table.
When a value in the right table doesn't have a corresponding match in the left table, you see a null value in the data grid.
| |
Full outer |
When you use a full outer join to combine tables, the result is a table that contains all values from both tables.
When a value from either table doesn't have a match with the other table, you see a null value in the data grid.
| |
Union | Though union is not a type of join, union is another method for combining two or more tables by appending rows of data from one table to another. Ideally, the tables that you union have the same number of fields, and those fields have matching names and data types. For more information about union, see Union Your Data. |
Comments
Post a Comment