How to Create Joins in Tableau

For the most current information, see Joining Tables in the Tableau Desktop Help.
Tableau supports relational joins without having to create a view table. Follow the instructions below to get started joining tables.

Step 1

Select the data source in the Data menu, and then select Edit Tables. In the Tables dialog box, click Add Table.

Tables dialog box with Add Table button highlighted

Step 2 

In the Add Table dialog box, select a table to add to the schema.

Add Table dialog box

Step 3

Select the Join tab, and add one or more join clauses by selecting a field from the original table, a field from the added table, and an operator. Then click Add to add it to the list of Join clauses.

Add Table dialog box Join tab

Step 4

When you finish defining your joins, click OK.
Notice that the schema is organized by tables, so you can easily identify where each dimension and measure came from.

Dimensions window with dimensions organized under headings
Note: When you select a table to add, you can optionally modify the Table Aliases and Field Aliases in the Add Table dialog box. Additionally, you can choose to exclude fields from the schema by selecting the check box next to each field alias that you want to include. Only the selected fields are shown in the schema.
For more information about how to join tables using Tableau Desktop, see Joining Tables in the Online Help. Alternate Search Terms:joins, tables, schema