Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
1 year ago
Solved

How to batch multiple Renamed Column steps into one step

I've just watched Chandeeps latest video where he talks about 'Batching' and removing unecessary steps for renaming columns. Unfortynately, he doesn't explain how to do this in the video: Cut Your P...
Need Help
Show and Tell
  • speedramps's avatar
    speedramps
    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_Jc

     

    Please click thumbs up and [accept solution] buttons.