Oz du Soleil demonstrates the Inner join in Get & Transform to merge two data sets. Oz shows both the why and the how.
- [Instructor] I'm going to show you the Inner Join in getting transformed. You and I are hosting a new product orientation. We have our list of people who are required in their department and the people who are actually enrolled and their session. Now we want to find out who's been cooperative. Who is required and enrolled. The Inner Join is going to answer that question of who is on both lists. Both data sets are in tables. We have to set up our queries. The cursor in a data set.
Data, from table. And I'm going to load this as a connection only because I've not done anything with this data, and loading it to the workbook would just add the same data. The arrow, close and load to, only create connection. You'll notice in the workbook queries pane that required query is listed as a connection only. Let's make the next query, cursors in the data set, from table.
There it is, and close and load as a connection only. Load. Now we can merge our queries and do our Inner Join. Here we go. New query, combine queries, merge. Let's go down here and select the Inner Join. And up top, that is the left side of our VIN diagram. And we're going to put the required data there. The bottom will be the enrolled.
We're going to match the names. Okay. Here we can see left and right is happening again. The left side, we see the name and department. On the right side, the name and session. They're collapsed in that third column. We can expand that. We don't want to use original column name as prefix. Okay. There it is. Let's close and load that to the workbook.
Let's look at this a little closer. And here's our data. And remember, the goal was to extract the cooperative people. The people who are both required and enrolled. Nobody else. These are our four cooperative people, and we know that because we used an Inner Join.
- What is Get & Transform?
- Querying data
- Working with columns
- Using formulas
- Pivoting and unpivoting data
- Grouping data
- Appending a query
- Merging/combining data with joins