search

tnclark8012 / Power-BI-Desktop-Query-Extensions

Various M Queries that you can use to make life easy-peasy
MIT License
67 stars 18 forks source link

Table.RenameColumns #10

Open tnclark8012 opened 7 years ago

tnclark8012 commented 7 years ago

NewNames= Table.ColumnNames(flatfile_header), RenameColumns = (table as table, index as number, newNames as list) => let oldName = Table.ColumnNames(table){index}, newName = newNames{index} in if index < List.Count(newNames) then @RenameColumns(Table.RenameColumns(table, {{oldName, newName}}), index+1, newNames) else table, Result = RenameColumns(#"Changed Type", 0, NewNames)

IvanBond commented 7 years ago

Hi Taylor, not sure you know, I have a post on this topic https://bondarenkoivan.wordpress.com/2015/04/17/dynamic-table-headers-in-power-query-sap-bydesign-odata/

Having rename_table you can rename columns without recursion:

"Renamed Columns" = Table.RenameColumns(TARGET_TABLE, Table.ToColumns(Table.Transpose(RENAME_TABLE)), MissingField.Ignore)