Forum Discussion
PowerQuery: Renaming fields
In column B you see that there is Beer, Pop and Water. In PowerQuery, how do I change this to a new value called "Beverages" ? I filtered for Beer, Pop, Water and replaced the value manu...
Anonymous
Here is one way of doing it
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Replacements = [ Beer = "Beverages", Pop = "Beverages", Water = "Beverages"], Replaced = Table.TransformColumns(Source, {{"Category", each Record.FieldOrDefault(Replacements, _, _)}}) in Replaced
Anonymous
Try
Change
Int-A
to
#"Int-A"
This worked but now it says, "Token Comma Expected"
And it ocurrs at
Replaced=....
in
Replaced