Forum Discussion

Aree's avatar
Aree
Icon for Resolver I rankResolver I
8 years ago
Solved

Query M Table.RenameColumns

Is it possible to rename multiple columns within a single line in the advance editor

 

#"Rename TarCon" = Table.RenameColumns(#"TarLike",{{"TargetConsequence_FieldValuesAsText","Target Consequence Assessment"}})

 

The above syntax renames a column from TargetConsequence_FieldValuesAsText to Target Consequence Assessmet. But it is possible to rename multiple columns at once or do i have to do each column rename one by one ?

Need Help
  • Aree's avatar
    Aree
    8 years ago

    Found the solution. :)

     

    #"Rename TarCon" = Table.RenameColumns(#"TarLike",{

    {"TargetConsequence_FieldValuesAsText","Target Consequence Assessment"},

    {"second column","new name}

    })

     

     

1 Reply

  • Aree's avatar
    Aree
    Icon for Resolver I rankResolver I
    8 years ago

    Found the solution. :)

     

    #"Rename TarCon" = Table.RenameColumns(#"TarLike",{

    {"TargetConsequence_FieldValuesAsText","Target Consequence Assessment"},

    {"second column","new name}

    })