Forum Discussion
How to batch multiple Renamed Column steps into one step
ArchStanton
Hi again
In answer to your question "My M code knowledge is very limited, can you provide an example of how this code will look"You can learn yourself.
Simply create some test data
Edit the query and overtype the columns.
The Power Query will automatically generate the the M rename code in the top window
If you click Advanced Editor then you can view the whole M script
This is how most developers learn M code,
by first using the wizard to crearte code
and then editing it.Learn more about Power Query for free here
https://www.youtube.com/watch?v=i66yyAl5_JcPlease click thumbs up and [accept solution] buttons.
Thanks, unfortunately I'm stuck with these multiple steps as the query fails when I remove and try to edit column name changes, this is because in the middle of all of these transformations - I have merged queries and done a whole host of other steps that I have unsuccessfully tried to pick apart and edit but failed.
Thanks for you help anyway
Hi again ArchStanton
In repy to your comment "Thanks, unfortunately I'm stuck with these multiple steps as the query fails when I remove and try to edit column name changes, this is because in the middle of all of these transformations - I have merged queries and done a whole host of other steps that I have unsuccessfully tried to pick apart and edit but failed."
Please can you kindly click [accept solutoon] because the solution works
I have provided you wth the solution, examples and a training video link but it sounds like you have given-up trying to implement it.
We all started as novices and had to go through the same excerise of unpicking M code to learn.
😀