From the course: Excel Power Query Tips and Techniques

Unlock the full course today

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

Duplicate a query vs. reference a query

Duplicate a query vs. reference a query

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Duplicate a query vs. reference a query

“

- [Instructor] All right, this is exciting. We're going to talk about duplicating versus referencing a query. Now see, I've got the 2017 donor data, all right? There's the raw data. Here is the summary that I created with the year 2017 query that you see over in queries and connections. And then here are the donors, okay. Now I've gotten the 2018 data that I've got to do the same thing to that I did to the 2017 data. I am not going to do all of that over again. Here's what I am going to do. Go over here, edit, okay, that's all of the work that I did to get this. Open this pane, right click. Duplicate the whole query. I'm going to call this 2018. Okay. Now, I'm going to go to my source, open this up a bit so I can see more. All right, it is pointing to the table that's called 2017. You know what I'm going to do. I'm going to point it to the table that is named 2018. Enter, boom. Simple. Duplicate the…

Contents