Oz du Soleil demonstrates the Full Outer join in Get & Transform to merge two data sets. Oz shows both the why and the how.
- [Instructor] I'm going to show you…a full outer join in Get & Transform.…You and I are hosting a new product orientation…and we have these two lists.…The people who are required to attend…and their departments and the people…who are enrolled and their session.…Our goal is to create a master list,…bring everybody together, including their department,…session and where there's a match…on the left side and the right side…we want those all on one row.…Here's the full outer join.…
Both data sets are already in tables,…so let's make our queries.…With the cursor in the data set, the data, From Table.…And here is our list of people who are required…and I'm going to close and load this as a connection only…because if I load it to the workbook…it's just going to be the same information…that we already have.…Okay go to this arrow, close and load to.…Only create connection, load it.…
Okay?…And notice on the right side in the workbook queries panel…this is loaded as a connection only.…And let's do that on the enrolled side.…
AuthorOz du Soleil
- 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
Skill Level Intermediate
1. What Is Get & Transform?
2. Working with Queries
3. Working with Columns
4. Working with Formulas
5. Pivoting and Unpivoting Data
Group data2m 31s
7. Appending a Query
8. Merging Data with Joins
9. Putting It All Together and Applying Your Learning
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.