Power Query: Rename Columns from a Mapping Table (Inline step)

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.

Custom Column in applied steps

Power Query code that you will use in the Custom Column.

(Use let and in Inside Steps)

Custom column step

Need a code snippet? Free of charge =)

pq_RenameColumnsBulk.txt

Download TXT • 1KB