Prepare Your Data for Tableau: A Practical Guide to the Tableau Data Prep Tool

© Tim Costello, Lori Blackshear 2020

T. Costello, L. BlackshearPrepare Your Data for Tableauhttps://doi.org/10.1007/978-1-4842-5497-4_4

4. UNION Joins

Tim Costello¹  and Lori Blackshear²

(1)

Euless, TX, USA

(2)

Fort Worth, TX, USA

 

In this chapter we will dive deep into the workings of the UNION join in the Data Prep Builder. To set the stage, let’s talk about what a UNION join does. A very common data scenario might involve receiving multiple text files from multiple locations within your company. Each text file contains the same columns of data, but the rows themselves will be unique. Our goal in this scenario would be to somehow combine all these individual files into one master file that contains data for every location. You might have worked through ...