Record Functions
Functions for creating, accessing, and transforming records.
- Record.AddFieldReturns a new record with an additional field added. Raises an error if the field already exists.
- Record.CombineMerges a list of records into a single record.
- Record.FieldReturns the value of a specific field from a record.
- Record.FieldCountReturns the number of fields in a record.
- Record.FieldNamesReturns a list of field names from a record.
- Record.FieldOrDefaultReturns the value of a named field from a record, or a default value if the field does not exist.
- Record.FieldValuesReturns a list of field values from a record.
- Record.FromListCreates a record from a list of values and a set of field names.
- Record.FromTableConverts a two-column table (Name, Value) into a record, using the Name column as field names and Value as field values.
- Record.HasFieldsReturns true if a record contains all of the specified field names.
- Record.RemoveFieldsReturns a record with the specified fields removed.
- Record.RenameFieldsRenames one or more fields in a record by specifying a list of {oldName, newName} pairs.
- Record.ReorderFieldsReturns a new record with fields reordered according to the specified list. Fields not in the list follow after in their original order.
- Record.SelectFieldsReturns a record containing only the specified fields.
- Record.ToListConverts a record to a list of its field values.
- Record.ToTableConverts a record into a two-column table with columns Name and Value.
- Record.TransformFieldsApplies transformation functions to specified fields in a record, returning a new record with the transformed values.