Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions

Transformation Language Reference

Transformation Language Reference

MAP_VALUES

MAP_VALUES

Returns an array of value elements for the specified map.

Syntax

MAP_KEYS(map as MAP)
The following table describes the arguments for this command:
Argument
Required/Optional
Description
map
Required
Map data type. Map with key-value pair elements from which you want to retrieve the values. You can enter any valid transformation expression.

Return Value

Array.
The data type of values in the map determines the data type of the array elements. For example, if the value is of integer type, the function generates array data with integer elements.
Returns -1 if the map value is null.
Returns NULL if the map is null.

Examples

The following expression generates an array with elements of string type.
MAP_VALUES(stock_sellprice)
stock_sellprice
RETURN VALUE
[AAPL -> 150.45, GOOGL -> 1150.96]
[150.45, 1150.96]
[AMZN -> 1400.54, TSLA -> 339.63]
[1400.54, 339.63]

0 COMMENTS

We’d like to hear from you!