Forum Discussion

aoliver's avatar
aoliver
Helper III
7 years ago

Conditional Renamed Columns

Hi everyone

It is possible to change the name of a column in powerQuery depending of the previous name? 
I am trying it in advance editor but I cant reach a solution of this, an example would be very apreciated.

 

Thanks in advance,

 

Need Help
Tutorial Requests

4 Replies

    • aoliver's avatar
      aoliver
      Helper III
      7 years ago

      let
      Source = Table.Combine({#"tempAmb(DateStart)",#"tempAmb(DateEnd)"}),

      - Here, i want to check if there is a column with the name:"firstName"

      #"Renamed Columns" = Table.RenameColumns(Source,{{"firstName", "secondName"}})
      in
      #"Renamed Columns"

       

      So, if the query has a column called "firstName" it will be call "secondName" at the end.

      I'll hope that this example would be enough to understand the problem, if not, I can write pseudocode PattemManohar 

      Thanks 

       

    • PattemManohar's avatar
      PattemManohar
      Community Champion
      7 years ago

      aoliver  You can try unpivoting the columns and then replace the values under Attribute field from FirstName to SecondName, then finally pivot the table again.