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

Hi Anonymous,

 

Yes that was mine as well but it achieved what I wanted to achieve with removing columns but I've tried using it to do rename and unfortuantely my PQ is not good enough to actually effect the change.

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.