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) } ) )

 

Luthiendsa's avatar
Luthiendsa
New Member
7 years ago

Hi ImkeF,

 

Where do I put the " #"Rename Columns" = Table.RenameColumns(Table2, List.Zip( { Table.ColumnNames(Table2), Table.ColumnNames(Table1) } ) ) "?

I am a beginner in Power BI and I really could use the solution you gave.