Join and union

The ability to enable vital decisions with a few tools across multiple data tables is taking self-service analytics to the next level. The tools that we will review in this section include Join, Join Multiple, and Union. These core tools allow joining two inputs together using the Join tool, joining more than two inputs together using the Join Multiple tool, and combining two or more data streams together. Volumes of data can be streamlined within minutes using these helpful, powerful tools. Let's continue using the same workflow from the last section.

Join

We'll begin this section by joining multiple files together. This can also be done using database tables, as the Join logic the same - the only difference is where the data comes from. The purpose is to identify the Average Age for all the cities in the Florida Local Data for Better Health.csv file. Let's go through how the Join tool can be applied in a workflow.

Step 1: Using an Input Data tool, connect to the file Florida...