Forum Discussion

vancromy's avatar
vancromy
Frequent Visitor
8 years ago
Solved

PQ - Rename Column Names based of column names from another table

Hi.   I'm sure this is really simple but I can't seem to find the answer online. Many queries are about translating rows to Column Names but I'm specifically after how I can make the column names o...
Need Help
  • ImkeF's avatar
    ImkeF
    8 years ago

    You were pretty close already:

     

    #"Rename Columns" = Table.RenameColumns(Table2, List.Zip( { Table.ColumnNames(Table2), Table.ColumnNames(Table1) } ) )

     

ImkeF's avatar
ImkeF
Community Champion
8 years ago

You were pretty close already:

 

#"Rename Columns" = Table.RenameColumns(Table2, List.Zip( { Table.ColumnNames(Table2), Table.ColumnNames(Table1) } ) )

 

vancromy's avatar
vancromy
Frequent Visitor
8 years ago

Thanks both! That's done the trick and I've learnt about a new PQ function in the process :)