Record.RenameFields
Applies rename(s) from a list in the form { old, new }.
function (record
as record,renames
as list, optionalmissingField
as nullable any) as record
Returns a record after renaming fields in the input
record
to the new field names specified in list renames
. For multiple renames, a nested list can be used ({ {old1, new1}, {old2, new2} }.Record.Transformations
Rename the field "UnitPrice" to "Price" from the record.
Record.RenameFields([OrderID = 1, CustomerID = 1, Item = "Fishing rod", UnitPrice = 100.0], {"UnitPrice","Price"})
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]
Rename the fields "UnitPrice" to "Price" and "OrderNum" to "OrderID" from the record.
Record.RenameFields([OrderNum = 1, CustomerID = 1, Item = "Fishing rod", UnitPrice = 100.0], { {"UnitPrice", "Price"}, {"OrderNum", "OrderID"} })
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]
Last modified 4yr ago