From the course: Tableau 10 for Data Scientists
Unlock the full course today
Join today to access over 23,300 courses taught by industry experts.
Merge data using unions - Tableau Tutorial
From the course: Tableau 10 for Data Scientists
Merge data using unions
- [Narrator] So if you're looking at the Weather file in your Exercise folder, we can see that we have four sheets showing the amount of rainfall for several cities in the US. Now often, what'll happen is that you'll have some kind of master document and people will fill in this information in this sheet and then they'll start a new sheet and fill in more information. In the example here, we have the January rainfall and then one for April, July and October. Now, what we could do is we could create a fifth sheet and we could copy the information together, merge it all together, add a second column for the month. But that's really messy. It'd be much nicer to be able to do that straight in Tableau. We'll get into Tableau, and we'll connect to the same sheet. So Tableau has found all four sheets and then we can pull one of them into the view. So let's put January into here. Now what we'd really like to do is be able to merge the additional sheets into Tableau. To do that, we're just…
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.