Record functions
Record functions functions for Power Query M language.
Functions
| Function | Description |
|---|---|
| Geography.FromWellKnownText | Converts text that represents a geographical value in Well-Known Text (WKT) format into a structured record. WKT is a standardized format developed by the Open Geospatial Consortium (OGC) and is commo... |
| Geography.ToWellKnownText | Converts a structured geographic point value into its Well-Known Text (WKT) representation according to the specifications set by the Open Geospatial Consortium (OGC). This format is commonly used as ... |
| GeographyPoint.From | Generates a data entry that represents a specific location on Earth using its individual components, like longitude, latitude, and, when available, elevation (Z) and measure (M). A unique spatial refe... |
| Geometry.FromWellKnownText | Converts text that contains information about a geometric value in Well-Known Text (WKT) format into a structured record. WKT is a standardized format created by the Open Geospatial Consortium (OGC) a... |
| Geometry.ToWellKnownText | This function converts a specific geometric point value into its Well-Known Text (WKT) format according to the standards set by the Open Geospatial Consortium (OGC). WKT is commonly utilized as the se... |
| GeometryPoint.From | Generates a data entry that represents a geometric point, using its fundamental components like X coordinate, Y coordinate, and optionally Z coordinate and measure (M). Users have the option to provid... |
| Record.AddField | This function will append a new field to a specific record. It requires the field name (fieldName) and the corresponding value (value) to be provided as parameters. |
| Record.Combine | Merges the data in the specified records. If the records contain non-data values, an error will be generated. |
| Record.Field | This function retrieves the value stored in the specified field. It is designed to generate field lookup syntax dynamically for a specific record. Essentially, it is a dynamic alternative to using the... |
| Record.FieldCount | This function retrieves the count of fields in the specified record. |
| Record.FieldNames | This function retrieves the names of the fields in the specified record and returns them as text. |
| Record.FieldOrDefault | This function retrieves the value of a specific field within a given record. If the field is not found, the defaultValue parameter is returned as an optional fallback option. |
| Record.FieldValues | Returns a collection of the values stored in the fields of the specified record. |
| Record.FromList | The function retrieves a data record based on a specified list of field values and a set of fields. Fields can be identified using either a list of text values or a record type. An error will be gener... |
| Record.FromTable | This function retrieves a single record from a table of records. The record includes both field names and their corresponding values, represented as pairs like {[Name = name, Value = value]}. If dupli... |
| Record.HasFields | This function checks if a record contains specified fields by returning a logical value (true or false). Multiple field values can be provided in a list format. |
| Record.RemoveFields | This function retrieves a record that excludes all the fields listed in the specified list from the original record. An error is thrown if the specified field does not exist in the record. |
| Record.RenameFields | This function creates a new record with renamed fields while maintaining the original order. It allows for swapping and chaining field names. However, all new field names, as well as the existing fiel... |
| Record.ReorderFields | Returns a modified record with the fields reordered based on the specified list called fieldOrder. The values of the fields remain the same, and any fields not included in the fieldOrder list will ret... |
| Record.SelectFields | The function retrieves a new data entry that includes specific fields chosen from the original data entry. The sequence of the fields remains the same as in the original data entry. |
| Record.ToList | This function retrieves a list of values that includes the field values from the input record. |
| Record.ToTable | Generates a table that includes the columns Name and Value, with each field from the record represented as a row in the table. |
| Record.TransformFields | This function returns a modified record by applying specified transformations from a list called transformOperations. Transformation can be done on one or more fields at a time. When transforming a s... |