Replace column names

[MasterSonic]

Hello,

Is there a way to bull change column names in table1

I have a Excel file with old->new names key.

It can be loaded as NewName column in table2

Is there way to do it?

Something like

 transformcolumnnames. Text.replace

for many columns at once.

[PaulOlding · Accepted solution]

Hi @MasterSonic 

You may get a better answer than this in the Power Query forum, but here's something I've used to do this:

Table.TransformColumnNames(#"Previous Step", each if List.PositionOf(column_name_table[OldName], _) = -1 then _ else column_name_table[NewName]{List.PositionOf(column_name_table[OldName], _)} )

[MasterSonic]

works like a charm