How to use multiple tables without joining in Tableau?

@jerrod 

In Tableau, you can use multiple tables in your analysis without joining them by creating a blended axis. Here's how:

1. Drag one of the tables onto the canvas, and place it on the Rows or Columns shelf.
2. Drag the second table onto the canvas, and place it on the Rows or Columns shelf as well.
3. Right-click on the second table's axis, and select "Dual Axis" from the context menu. This will create a second, independent axis for the second table.
4. To control the display of each axis separately, click on the second table's axis and select "Synchronize Axis" from the context menu. This will allow you to control the axis scales and formatting for each table separately.
5. You can now use measures and dimensions from both tables on the same visualization, without joining the tables.

Note: If you want to use measures or dimensions from both tables in the same calculation, you will need to use a custom calculated field to reference the fields from both tables.

I hope this helps! Let me know if you have any questions.

@jerrod 

Actually, Tableau is designed to work with single tables at a time, and joining tables is the recommended way to combine data for analysis. However, there are some workarounds to use multiple tables without joining them:

1. Create separate worksheets: You can create individual worksheets for each table and then combine them on a dashboard. This allows you to present multiple tables side by side on the same dashboard without joining them.
2. Use data blending: Tableau has a feature called data blending that allows you to combine data from multiple tables based on a common field. To utilize data blending, you should have a primary data source and then add additional secondary data sources. You can then use the common field to blend the data.
3. Use custom SQL: If you have a SQL background, you can use custom SQL to combine data from multiple tables in a single query. This allows you to create a unified view of the tables within Tableau.

These methods have their limitations and may not be suitable for every scenario. It is generally recommended to join tables to take full advantage of Tableau's capabilities such as filtering, aggregating, and creating calculated fields.