Oz du Soleil addresses the common need to bring multiple data sets together into one by stacking them all up—formally called appending data. See how easily this is done in Get & Transform.
- [Instructor] Here you'll see how to stack up…multiple data sets.…Here we have three different data sets representing…three different sessions of mandatory fun…that our company hosted.…Our goal now is to get everybody matched up…into one big list.…But first let's notice a few things.…One, all three data sets have a name column.…Two sets have a department column,…and two sets have a work location.…We'd like all of that lined up wherever…it's appropriate.…
Our data sets are already in tables,…we just have to now create queries so that we can…append those three queries.…Let's get started with the cursor in the data set,…and with the Data tab in the ribbon selected.…We make a query from Table.…Here's our Session1 query that we're just going to close…and load as a connection.…Load, Close and Load To.…Only Create Connection.…Load.…
And we see on the right side…in the Workbook Queries pane,…the Session1 query is a Connection only.…Let's make the other two.…With the cursor in the next data set,…From Table,…Close and Load,…Only Create Connection.…
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.