Record.TransformFields

Search…
Record.TransformFields
Returns a record after applying specified transformations.
function (record as record, transformOperations as list, optional missingField as nullable any) as record
Description
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} }
Category
Record.Transformations
Examples
Convert "Price" field to number.
1
Record.TransformFields([OrderID = 1, CustomerID= 1, Item = "Fishing rod", Price = "100.0"], {"Price", Number.FromText})
Copied!
[OrderID = 1, CustomerID= 1, Item = "Fishing rod", Price = 100]
Convert "OrderID" and "Price" fields to numbers.
1
Record.TransformFields(
2
    [OrderID ="1", CustomerID= 1, Item = "Fishing rod", Price = "100.0"], 
3
    { {"OrderID", Number.FromText}, {"Price",Number.FromText} })
Copied!
[OrderID = 1, CustomerID= 1, Item = "Fishing rod", Price = 100]
Record.ToTable
Replacer
Last modified 3yr ago
Copy link
Contents
Record.TransformFields
Description