From the course: Excel: Power Query (Get & Transform) (2020)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Load data only as a connection
From the course: Excel: Power Query (Get & Transform) (2020)
Load data only as a connection
- [Instructor] A common question asked about Power Query is why do you load as connection only? That's what we're going to talk about here. Basically, it helps reduce clutter. If you don't need the end result of a query in the workbook then just load it as a connection only. Keep it out of the way. Here we've got two datasets that we just want to stack up. We've got the first name and last name in columns B and C and then in G we have the names that are stuck together. We've got to split those out. And we don't want the birthdays. Another thing, we want to get rid of some duplicates. Rosemary George is in both lists. Hiro Chavez is in both lists. We want to get rid of that duplicate. All right, let's get into it. Cursor in the dataset. Table does have headers. Now because I am not doing anything to this dataset I don't want to load it into the workbook because it's the same information. So I'm just going to close and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.