Oz du Soleil demonstrates the Left Anti join in Get & Transform to merge two data sets. Oz shows both the why and the how.
- [Instructor] Let's tackle the left Anti Join.…You and I are hosting a new product orientation…and we have two lists,…lists of people who are required…and lists of people who are enrolled.…Now we have a question.…Who are the people who are required…and not enrolled?…We can see the Eunice is on the required list…and is not enrolled,…but we aren't going to go through…this whole list and eyeball it,…we're going to use the left Anti Join.…
Let's do it.…Our datasets are already in tables.…Let's make our queries.…With the cursor inside one dataset,…got to Data, From Table.…And here is our required data.…I'm going to close and load this as a connection only,…because if I load it to the workbook,…it's going to be the same information that we already have.…Hit this arrow, Close & Load To,…Only Create Connection, Load.…
And notice in the Workbook Queries pane,…we have our Required query and it is indeed loaded…as a connection only.…Now let's make our enrolled query.…With the cursor in the dataset,…Data tab, From Table.…And there is our unadulterated data,…
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.