# Structural functions

This section describes the following structural functions:

| Function | Description |
| --- | --- |
| [FROM_KEY_VALUE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/from_key_value.htm) | Maps a list of key values to a record with fields for each key |
| [GET_RANGE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/get_range.htm) | Returns a range of numbers between start and end (inclusive) |
| [JOIN_ALL_BY_KEY](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/join_all_by_key.htm) | Combines multiple key-value arrays into one by the keys |
| [JSON_PATH](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/json_path.htm) | Extracts data from JSON objects |
| [JSON_TO_RECORD](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/json_to_record.htm) | Extracts data from JSON objects |
| [MAP_WITH_INDEX](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/map_with_index.htm) | 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](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/query_string_to_record.htm) | Extracts data from a query string |
| [RECORD_TO_JSON](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/record_to_json.htm) | Converts the record containing the field to a JSON string |
| [SORT_BY](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/sort_by.htm) | Sorts the values array by the sortKeys array |
| [TO_ARRAY](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/to_array.htm) | Outputs all the values from all the inputs as an array |
| [ZIP](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/zip.htm) | Combines multiple arrays by index into records |
| [ZIP_WITH_INDEX](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/structural/zip_with_index.htm) | Combines multiple arrays by index into records |