Power Query: Rename Columns from a Mapping Table (Inline step)
Apr 19, 2025
1 min read
Updated: Oct 3
PRACTICE MATERIAL BELOW!👇
Function: Would you like to rename multiple columns in a single operation? This custom step allows you to rename as many columns as needed. You need one mapping table (let's call it "RenameTbl") with columns: OldName and NewName, and then reference it simply with a Custom Column step. Yellow markings indicate the difference between Old and New Columns after the custom step.
Power Query code that you will use in the Custom Column.
(Use let and in Inside Steps)
Need a code snippet? Free of charge =)
Reuse your Power Query work
Build on your column-mapping workflow with reusable Power Query transformation patterns.
Need help adapting this to your data? Discuss your project.
Comments