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 - Tableau Tutorial
From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.