Structural
This section describes the following structural functions:
| Function | Description |
|---|---|
| FROM_KEY_VALUE | Maps a list of key values to a record with fields for each key |
| GET_RANGE | Returns a range of numbers between start and end (inclusive) |
| JOIN_ALL_BY_KEY | Combines multiple key-value arrays into one by the keys |
| JSON_PATH | Extracts data from JSON objects |
| JSON_TO_RECORD | Extracts data from JSON objects |
| MAP_WITH_INDEX | Outputs an index and a value field. The index contains a zero-based index, and the value contains the value in the input field |
| QUERY_STRING_TO_RECORD | Extracts data from a query string |
| RECORD_TO_JSON | Converts the record containing the field to a JSON string |
| SORT_BY | Sorts the values array by the sortKeys array |
| TO_ARRAY | Outputs all the values from all the inputs as an array |
| ZIP | Combines multiple arrays by index into records |
| ZIP_WITH_INDEX | Combines multiple arrays by index into records |