Query M Table.RenameColumns

[Aree]

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 ?

[Aree · Accepted solution]

Found the solution. 🙂

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

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

{"second column","new name}

})