From the course: Excel Power Query Tips and Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Navigate to new source

Navigate to new source

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Navigate to new source

“

- [Narrator] Here is some data that's being pulled in from a folder. We've got a folder that has January, February, March data, and then look at this, this is sweet, I'm going to show you this. Over here I made an added conditional column. I wrote this myself, and I am proud, and then somebody comes and says, "Aye, hold on a second, that folder you're pulling from, "it's got old data, it's incomplete, leave it alone. "Here is a folder with the complete data." Oh, okay, so this I am pulling from "Events." It's got these three files in it, and then "Events - Updated," okay, it's got data going up until June. Alright. Do I want to rewrite my query? No, this is what we do. We just point the query to a new source. Here we go. Edit. Go to source. The box comes up, browse. Go to "Events - Updated," okay. Okay. Scroll down. There is our data. Close and load it. Boom, we got June. We've got new people…

Contents