From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Merging data using unions

Merging data using unions - Tableau Tutorial

From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep

Start my 1-month free trial

Merging data using unions

- [Instructor] Unions are a way of combining data across multiple sheets or multiple tables or multiple files within our data sources. The way that union works is, as long as the data structure is similar, the road from the second data source will be added to the first and so on and so on across all of the applicable data sources. There's three different ways we can use unions in Prep. We going to look at manual step of creating a union where we're going to start off with a single table and then we're going to add in some additional tables. The third way is a wildcard union, which you will look at in a later video. I'm going to use the weather data, which you can find in your data folder. So first of all, we going to connect to our excel file. This is called weather. Now in this workbook, I've got four sheets. One for each month and ultimately, I want to combine all of these together into a single file. So first of all, I'm going to put in January. I can see I've got three columns…

Contents