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.TransformFields(record as record, transformOperations as list, optional missingField as nullable number) as record
About
Returns a record after applying transformations specified in list transformOperations to record. One or more fields may be transformed at a given time.
In the case of a single field being transformed, transformOperations is expected to be a list with two items. The first item in transformOperations specifies a field name, and the second item in transformOperations specifies the function to be used for transformation. For example, {"Quantity", Number.FromText}
In the case of a multiple fields being transformed, transformOperations is expected to be a list of lists, where each inner list is a pair of field name and transformation operation. For example, {{"Quantity",Number.FromText},{"UnitPrice", Number.FromText}}
Example 1
Convert "Price" field to number.
Usage
Record.TransformFields(
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = "100.0"],
{"Price", Number.FromText}
)
Output
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100]
Example 2
Convert "OrderID" and "Price" fields to numbers.
Usage
Record.TransformFields(
[OrderID = "1", CustomerID = 1, Item = "Fishing rod", Price = "100.0"],
{{"OrderID", Number.FromText}, {"Price", Number.FromText}}
)
Output
[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100]