VALUES
- VALUES(value)[source]
Extracts the values from a map and returns them as an array.
The VALUES function takes a model component with a map data type and converts its values into an array.
- Parameters:
value (
Operand) – A model component of type MapDataType whose values will be extracted.- Return type:
- Returns:
An array containing the values of the map.
- Raises:
ValueError – if the input is not of type MapDataType.
Examples
Extracting values from a map:
VALUES(my_map) # Returns ["a", "b", "c"] for a map {0: "a", 1: "b", 2: "c"}
``value`` — accepted types
BOOLEAN_MAP
DATETIME_MAP
DATE_MAP
DECIMAL_MAP
INTEGER_MAP
STRING_MAP
TIME_MAP
Return types
BOOLEAN_ARRAY
DATETIME_ARRAY
DATE_ARRAY
DECIMAL_ARRAY
INTEGER_ARRAY
STRING_ARRAY
TIME_ARRAY