Forum Discussion
Dynamically rename column based on a mapping table
Hi tranpeter ,
You can refer the following links to rename column names dynamically:
Dynamically rename columns from a column names table
Table.RenameColumns( Source, List.Zip( {fOldColumnNames("TableName"), fNewColumnNames("TableName") } ) )Using M to dynamically change column names in PowerQuery
Dynamic Column Names in Power Query
Any comment or problem, please feel free to let me know.
Best Regards
A coworker pointed me to this solution. I'll have to give it a try and update this post on whether this worked.
Hi tranpeter ,
You can refer the following links to rename column names dynamically:
Dynamically rename columns from a column names table
Table.RenameColumns( Source, List.Zip( {fOldColumnNames("TableName"), fNewColumnNames("TableName") } ) )Using M to dynamically change column names in PowerQuery
Dynamic Column Names in Power Query
Any comment or problem, please feel free to let me know.
Best Regards
Hi tranpeter ,
Did you get it worked? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards