Tableau data union functionality allows us to merge multiple tables by appending the rows of one table to another.
Data union
Getting ready
In this recipe, we'll be using the Bread_basket_by_year.xlsx file, so make sure you have saved it to you device.
How to do it...
- Upon opening Tableau, from the Connect pane on the left-hand side, choose Microsoft Excel:
- When the Open window opens, navigate to your local copy of Bread_basket_by_year.xlsx, select it, and click Open.
- On the Data Source page, two tables contained within our data source, 2017 and 2018, appear....