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.

Move, insert, and delete query steps

Move, insert, and delete query steps

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Move, insert, and delete query steps

“

- Let's talk about moving, inserting and deleting steps in a query. Right, so the first thing I'm going to do, is because we're going to be playing with these queries, I'm going to duplicate a query so that, yeah when I deliberately break this it won't be broken for real. All right. So I'm going to right-click and duplicate the query. Now we can play. Okay. Inserting a step. Let's say we realize here that the contractor Clint no longer works with us. So I could go earlier in the query, let's say right here, and then filter out Clint. Okay. Clint is gone. Let's go down to the bottom of the query. The entire query still works. That was not a problem. We can move steps. Let's say I want to filter out Clint later. Let's move him down here. That's fine. We can even remove a step if we're careful. So let's go to a Changed Type. I can delete that. Okay. No problem. Go to the end. It still works.…

Contents