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.
Rename queries
- [Instructor] We got a lot of data here. We've got eight queries over on the left side that you can see. We've got four tables here. We've got tables here. We got tables all over the land. All right. But look what's happening. Over in the queries and connections, we see we've got an airports query, that means something to us in the data. But then merge one, merge two, what are those? Those are generic names that Power Query made when I did the merges. So it would help us to stay organized for me to rename these as something useful. So what is this merge one? Okay, that has the managers, the budgets, and the projects. So I'm going to right click, rename. Call this projects and budgets. Enter. All right, merge two. Let's go into this so that I can show you another way to change the query name. We'll go to edit. Now what was this? This is contractor details. So over here where it says merge two, I'm…
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.
Contents
-
-
-
-
-
(Locked)
Navigate to new source1m 53s
-
(Locked)
Change load-to destination1m 10s
-
(Locked)
Reference a query4m 9s
-
(Locked)
Duplicate a query: Recycling47s
-
(Locked)
Duplicate a query vs. reference a query2m 37s
-
(Locked)
Delete steps until the end32s
-
(Locked)
Cross join: Matching everything with everything2m 29s
-
(Locked)
Rename queries1m 35s
-
(Locked)
Copy and paste queries to a new workbook1m 40s
-
(Locked)
Merging and segmenting data: Anti-join2m 41s
-
Merge queries as new1m 51s
-
(Locked)
-