Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Change column header names in Power Query

Hi,   Trying to change a column header names using Power Query.   The issue is that as I am doing this to multiple imports the column title isn't "fixed" it is the default "ColumnNN" and it could...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Ok no worries.  My quick napkin attempt would be something like:

     

    #"Renamed Columns" = Table.RenameColumns(#"Name_of_your_previous_step",{{List.Last(Table.ColumnNames(Name_of_your_previous_step), "RenamedName"}})

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Ok no worries.  My quick napkin attempt would be something like:

 

#"Renamed Columns" = Table.RenameColumns(#"Name_of_your_previous_step",{{List.Last(Table.ColumnNames(Name_of_your_previous_step), "RenamedName"}})

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,

 

Thanks for that. Works great!

 

Almost had it but didn't quite have the syntax with the braces right so sincerely appreciate the assist,

 

Cheers,

Andrew.