Combine replace value steps?

Me again, I am combining steps to clean up my Query Editor. E.g. Renaming columns all in one step rather than all over the shop. I want to combine Table.ReplaceValue steps but it doesn't seem t...

Need Help

Anonymous

Not applicable

7 years ago

Hi Dale,

Sorry for the delay in response.

I cannot attach the dataset but I have screenshots of what i'm talking about.

So I have 20 Replaced Value steps.

I had about the same number of steps for Renamed Columns and Changed Type, and I was able to combine these steps into one single step each using M-Query in the formula bar by using curly brackets and coma separators.

I want to do the same for the Replaced Value steps. However applying the same logic as I did for the Renamed Columns steps, does not work for Replaced Value.

So to summarise, I am wondering if it is possible to combine 'Replaced Value' Applied Steps using M-Query in the formula bar.

Example of where I have combined multiple steps of renaming columns by splitting using {},First Replace Value StepSecond Replace Value StepThird Replace Value StepApplied steps shows all the Replaced Value Steps