Record.TransformFields

About

Transforms fields by applying transformOperations. For more more information about values supported by transformOperations, see Parameter Values.

Syntax

Record.TransformFields(record as record,  transformOperations as list,  optional missingField as nullable number) as record  

Arguments

Argument Description
record The Record to modify.
transformOperations The list of transformations to make.
optional missingField A MissingField enum value to handle missing fields. The default value is MissingField.Error.

MissingField enum

  • MissingField.Error = 0;

  • MissingField.Ignore = 1;

  • MissingField.UseNull = 2;

Examples

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