Power Query

📄️ Geography.FromWellKnownText

Translates text representing a geographic value in Well-Known Text (WKT) format into a structured record.

Translates a structured geographic point value into its Well-Known Text (WKT) representation.

Creates a record representing a geographic point from parts.

Translates text representing a geometric value in Well-Known Text (WKT) format into a structured record.

Translates a structured geometric point value into its Well-Known Text (WKT) representation.

Creates a record representing a geometric point from parts.

Adds a field to a record.

Combines the records in the given list.

Returns the value of the specified field in a record.

Returns the number of fields in the record.

Returns the names of the fields.

Returns the value of the specified field in a record or the default value if the field is not found.

Returns a list of the field values.

Returns a record given a list of field values and a set of fields.

Creates a record from a table of the form \{[Name = name, Value = value]}.

Indicates whether the record has the specified fields.

Removes the specified field(s) from the input record.

Applies rename(s) from a list in the form \{ old, new }.

Reorders the field(s) specified into the new order.

Returns a record that contains only the specified fields.

Returns a list of values containing the field values of the input record.

Returns a table with each row being a field name and value of the input record.

Returns a record after applying specified transformations.