Expanding datasets using a not inner join
In this chapter, we have assumed in all join-related recipes that there was an overlap between two data sources. However, for analysis purposes, you may be interested in what data is not overlapping, so that you can take action appropriately.
Using the same data as we've used in the Expanding datasets using a full outer join recipe, where we have a data source with projects, and another data source with project staff, we may change our use case to focus solely on data that does not overlap. That is, we are only interested in projects without staff assigned to them, or staff members not currently assigned to work on any project.
Getting ready
To follow along with this recipe, download the Sample Files 5.6 folder from this book's GitHub repository.
How to do it…
Start by opening Tableau Prep and perform the following steps to create a not inner join:
- Connect to the Projects.xlsx Excel file in order to create...
