From the course: Excel Power Query Tips and Techniques

Merge queries as new

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Merge queries as new

“

- [Narrator] We've got these two queries: categories and transactions. Take a look. All right, there it is. Now I want to merge these two, and we're going to do a merge queries as new, but first I'm going to show you something really cool that's brand new in Power Query. Look at this. I want to merge the R-R one, the L-C five. That's what we're going to merge. I want to peel this out before your very eyes. We have to go to split column. And where does it change? It changes at the digit to non-digit. So this is the selection. Ooh, ooh, ooh, wasn't that beautiful? All right, so that is what we're going to merge. Now, merging queries as new means I want to end up with a third query. If I just did a straight merge from here, it would merge categories with the transactions query. I don't want that. I want to have a third query in the end, so let's go ahead and do that combine. Merge queries, merge queries as new. I want to merge transactions with categories. Match these columns, and I want to do a left outer join. Okay, there is the merge. Let's expand, don't use this, and okay. Here is our data merged. Now we have the third query, and our original data is still available to us if we have to do more with those.

Contents