הערה
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות להיכנס או לשנות מדריכי כתובות.
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות לשנות מדריכי כתובות.
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]