Power Query Formulas - abdullahbintahir/Python-Snippet GitHub Wiki

Map table headers to combine files with different column headers. Create a query for mapping table and then refer the main query to this mapping query.

= Table.TransformColumnNames(DetectIT_Sheet, each
 List.Accumulate(Table.ToRecords(Mapping), _ ,
 (state, current)=> Text.Replace(Text.Upper(state), current[Before], current[After])))