Steps in advanced editor

[sigridr]

There used to be a way to merge all the applied steps in the advanced editor, so that it would only show up as the first step in query. But I can't seem to remember how to do it. 

Any suggesetions? 

[AlienSx · Accepted solution]

@sigridr first step only

let
    Source = 
    [step1 = 1,
    step2 = 2,
    stepx = step1 + step2][stepx]
in
    Source

no step name at all, just a query name

[step1 = 1,
step2 = 2,
stepx = step1 + step2][stepx]

[v-yanjiang-msft]

Hi @sigridr ,

You can merge all the applied steps in the advanced editor by selecting the last step in your query, then holding down the Shift key and selecting the first step. This should highlight all the steps in between as well. Once you've selected all the steps, right-click and choose "Merge Queries". This will create a new query with all the steps merged into one. Then, to make this new query the first step in your original query, simply drag and drop it to the top of the Applied Steps pane.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @sigridr ,

You can just put all your  steps inside a variable using the advanced editor

let x =
 applied steps...

in x