The data we are working in is often contained in multiple tables. We can create a single, virtual table out of multiple original tables by joining them using common fields or keys. The result is a wider table that contains columns originating from different tables. The rows are matched by the values of the column, key, and fields.
Joining data sources
Getting ready
In this recipe, we'll be using two datasets, Public_Schools_1.csv and Public_Schools_2.csv. Make sure you have both datasets saved to your device.
How to do it...
- Upon opening Tableau, from the Connect...
