Union your data
If a Join adds columns, a Union adds lines.
Unions are useful when you have two (or more) tables with an identical structure that you want to combine to create a unique Data Source.
The typical use case is when you receive an Excel file with one sheet per year, and you need to compare those years. To do that, you need to combine those different sheets into a single Data Source. You can, of course, spend some time copying and pasting the data into a new, big Excel file, but with Tableau and Unions, you can combine them in a few clicks.
Note
To create useful Unions, the different tables must contain the same column names. Otherwise, Tableau will not consider them identical and will create new columns.
Let's start with an example.
A Union example
For this example, I created an Excel file with two sheets to Union.
Note
If you want to reproduce the example, you can download the Union example
file from my website, book.ladataviz.com, in the section Chapter 4: Connect To Data and Simple...