Skip to main content

Record.TransformFields

Returns a record after applying specified transformations.

Syntax​

Record.TransformFields(
    record as record,
    transformOperations as list,
    optional missingField as MissingField.Type
) as record

Remarks​

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}}

Examples​

Example #1​

Convert "Price" field to number.

Record.TransformFields(
    [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = "100.0"],
    {"Price", Number.FromText}
)

Result:

[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100]

Example #2​

Convert "OrderID" and "Price" fields to numbers.

Record.TransformFields(
    [OrderID = "1", CustomerID = 1, Item = "Fishing rod", Price = "100.0"],
    {{"OrderID", Number.FromText}, {"Price", Number.FromText}}
)

Result:

[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100]

Category​

Record.Transformations