From the course: Tableau 10 for Data Scientists

Unlock the full course today

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

Merge data using unions

Merge data using unions - Tableau Tutorial

From the course: Tableau 10 for Data Scientists

Start my 1-month free trial

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…

Contents