Chapter 40: Making Queries Work Together
4040
After clicking OK, Power Query does two things. First, it moves all the extracted
steps to the newly created query. Then it ties the original query to the new query.
That is to say, both queries are sharing the first few query steps up until the
Grouped Rows step.
You can see the new SalesByBusiness query (see Figure 40.6) in the pane on the
left. Notice that the query steps for the newly created SalesByBusiness query do
not include the Grouped Row step. Power Query only moved the extracted steps
(those before the Grouped Row step).FIGURE 40.6
Your two queries are now sharing the extracted steps.This concept of extracting steps can be a bit confusing. The bottom line is that instead of
starting from square one with a new query, you’re telling Power Query that you want to
create a new query that utilizes the steps you’ve already created.When two or more queries share extracted steps, the query that contains the extracted steps serves as the data
source for the other queries. Because of this link, the query that contains the extracted steps cannot be deleted.
You’ll first have to delete all dependent queries before deleting the query that holds the extracted steps.
Understanding the Append Feature
Power Query’s Append feature allows you to add the rows generated from one query to the
results of another query. In other words, you’re essentially copying records from one query
and adding them to the end of another.