Oz du Soleil demonstrates the Left Outer join in Get & Transform to merge two data sets. Oz shows both the why and the how.
- [Instructor] Let's take on the Left Outer Join.…You and I are hosting a new product orientation…and we have two sets of data;…the people who are required, the people who are enrolled.…And, we have a question.…Of the people who are required to attend,…what sessions have they signed up for or not signed up for?…This is the equivalent of VLOOKUP in Excel…where we have one dataset that we want to complete,…but complete it with data from another dataset.…
And, that's exactly what the Left Outer Join…is going to do for us.…The datasets are already in tables.…Let's make our queries.…With my cursor in the dataset;…Data, From Table.…Here is the required dataset…and I'm going to load this as a connection only…because loading it to the workbook would just load…the same data we already have.…The arrow, Close & Load To.…
Only Create Connection, Load.…Notice in the workbook queries panel,…this required query is indeed setup as a connection only.…Let's make the enrolled query.…The cursor in the dataset.…From Table.…Close & Load To.…
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.