Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
5 years ago
Solved

PowerQuery rename columns by position inside a column with tables

Hello all,   Need help here. I´m trying to rename Columns by position, but my tables are inside a column. Here´s what I´m trying to do:   Thanks in advance
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Fcoatis 

    Use Table.ColumnNames to access the column name, referenced by position:

     

    Table.RenameColumns
(
   [Limpa],
   {
   {Table.ColumnNames([Limpa]){0},"Col1"},
   {Table.ColumnNames([Limpa]){1},"Col2"},
   {Table.ColumnNames([Limpa]){2},"Col3"},
   {Table.ColumnNames([Limpa]){3},"Col4"}
   }
)

     

     

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Fcoatis 

Use Table.ColumnNames to access the column name, referenced by position:

 

Table.RenameColumns
(
   [Limpa],
   {
   {Table.ColumnNames([Limpa]){0},"Col1"},
   {Table.ColumnNames([Limpa]){1},"Col2"},
   {Table.ColumnNames([Limpa]){2},"Col3"},
   {Table.ColumnNames([Limpa]){3},"Col4"}
   }
)

 

 

Regards

Phil

Fcoatis's avatar
Fcoatis
Post Patron
5 years ago

PhilipTreacy Thank you very much!!! It worked.