Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
Record.RenameFields(record as record, renames as list, optional missingField as nullable number) as record
About
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} }.
Example 1
Rename the field "UnitPrice" to "Price" from the record.
Usage
Record.RenameFields(
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", UnitPrice = 100.0],
{"UnitPrice", "Price"}
)
Output
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]
Example 2
Rename the fields "UnitPrice" to "Price" and "OrderNum" to "OrderID" from the record.
Usage
Record.RenameFields(
[OrderNum = 1, CustomerID = 1, Item = "Fishing rod", UnitPrice = 100.0],
{
{"UnitPrice", "Price"},
{"OrderNum", "OrderID"}
}
)
Output
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0]