Adding rows to our data model with unions and wildcard unions

Before beginning our exercises in Tableau Prep Builder, as mentioned in Chapter 3, in the Using Tableau Prep Builder to connect to data section, please make a note of the directory name where you have stored these files from GitHub:

• Sales Argentina.csv
• Sales Chile.csv
• Sales Colombia.csv
• Superstore Sales Orders - Canada.xlsx
• Superstore Sales Orders - US.xlsx

Create a sub-directory in the directory where you downloaded the files from Github. Call the sub-directory South America Sales and move the Sales Argentina.csv, Sales Chile.csv, and Sales Colombia.csv files into this new sub-directory. In this section, we will explore unions. Thinking back to our exploration of how Tableau likes data in Chapter 2, unions are a method of adding additional rows of data. This makes our data model longer. In the next section of this chapter, we will look at joins. Joins are a way to add new columns. Joins make...