Forum Discussion
How to batch multiple Renamed Column steps into one step
- 1 year ago
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.
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_Jc
Please click thumbs up and [accept solution] buttons.