Preface
The Transformation Language
Constants
Operators
Variables
- Built-in Variables
  - SYSDATE
    - Example
- Local Variables
Dates
Functions
- Function Categories
  - Aggregate Functions
  - Aggregate Functions and Nulls
    - Filter Conditions
  - Character Functions
  - Complex Functions
  - Conversion Functions
  - Data Cleansing Functions
  - Date Functions
  - Encoding Functions
  - Financial Functions
  - Numeric Functions
  - Scientific Functions
  - Special Functions
  - String Functions
  - Test Functions
  - Window Functions
- ABORT
- ABS
- ADD_TO_DATE
- AES_DECRYPT
- AES_ENCRYPT
- ANY
- ARRAY
- ASCII
- AVG
- CAST
- CEIL
- CHOOSE
- CHR
- CHRCODE
- COLLECT_LIST
- COLLECT_MAP
- COMPRESS
- CONCAT
- CONCAT_ARRAY
- CONVERT_BASE
- COS
- COSH
- COUNT
- CRC32
- CREATE_TIMESTAMP_TZ
- CUME
- DATE_COMPARE
- DATE_DIFF
- DEC_BASE64
- DECODE
- DECOMPRESS
- ENC_BASE64
- ERROR
- EXP
- EXTRACT_STRUCT
- FIRST
- FLOOR
- FV
- GET_DATE_PART
- GET_TIMEZONE
- GET_TIMESTAMP
- GREATEST
- IIF
- IN
- INDEXOF
- INITCAP
- INSTR
- ISNULL
- IS_DATE
- IS_NUMBER
- IS_SPACES
- LAG
- LAST
- LAST_DAY
- LEAD
- LEAST
- LENGTH
- LN
- LOG
- LOWER
- LPAD
- LTRIM
- MAKE_DATE_TIME
- MAP
- MAP_FROM_ARRAYS
- MAP_KEYS
- MAP_VALUES
- MAX (Dates)
- MAX (Numbers)
- MAX (String)
- MD5
- MEDIAN
- METAPHONE
- MIN (Dates)
- MIN (Numbers)
- MIN (String)
- MOD
- MOVINGAVG
- MOVINGSUM
- NPER
- PARSE_JSON
- PARSE_XML
- PERCENTILE
- PMT
- POWER
- PV
- RAND
- RATE
- REG_EXTRACT
- REG_MATCH
- REG_REPLACE
- REPLACECHR
- REPLACESTR
- RESPEC
- REVERSE
- ROUND (Dates)
- ROUND (Numbers)
- RPAD
- RTRIM
- SET_DATE_PART
- SIGN
- SIN
- SINH
- SIZE
- SOUNDEX
- SQL_LIKE
- SQRT
- STDDEV
- STRUCT
- STRUCT_AS
- SUBSTR
- SUM
- SYSTIMESTAMP
- TAN
- TANH
- TIME_RANGE
- TO_BIGINT
- TO_CHAR (Dates)
- TO_CHAR (Numbers)
- TO_DATE
- TO_DECIMAL
- TO_DECIMAL38
- TO_FLOAT
- TO_INTEGER
- TO_TIMESTAMP_TZ
- TRUNC (Dates)
- TRUNC (Numbers)
- UPPER
- UUID4
- UUID_UNPARSE
- VARIANCE

Transformation Language Reference

10.5
- 10.5.6
- 10.5.4
- 10.5.1

Back Next

Multidimensional Array

A multidimensional array is an array of arrays, which can have up to five levels of nesting. You can use subscript operators to access arrays at any level or specific elements in an array at the innermost level.

You can use subscript operators to return the following values:

A specific element in an array at the innermost level.

One or more arrays at any level.

A subset of one or more arrays at any level.

To access a specific element in an array at the innermost level, you use more than one subscript operator. The number of dimensions in a multidimensional array determines the number of subscript operators to use. Each subscript operator must contain one index value. The data type of the return value is the same as the data type of the elements in the array.

For example, in a two-dimensional array, you use two subscript operators. The first subscript operator determines which one-dimensional array to access. The second subscript operator determines which element to access within the array.

The following two-dimensional array contains three arrays and each array contains elements of type string:

menu_array = [
 ['milk','coffee','tea','chai'],
 ['ham','turkey',NULL],
 ['caesar','cobb','greek','chipotle']
]

The following expressions use two subscript operators to access a specific element from each one-dimensional array within the

menu_array

Input Value	RETURN VALUE
menu_array[0][1]	'coffee'
menu_array[2][3]	'chipotle'
menu_array[1][2]	NULL

The following expressions use a single subscript operator to return one-dimensional arrays in the

menu_array

Input Value	RETURN VALUE
menu_array[0]	['milk','coffee','tea','chai']
menu_array[0,2]	[ ['milk','coffee','tea','chai'], ['ham','turkey',NULL] ]
menu_array[1,0]	[ ]
menu_array[NULL,2]	NULL

The following expressions use two subscript operators to return a subset of arrays within the

menu_array

Input Value	RETURN VALUE
menu_array[0][0,2]	['milk','coffee']
menu_array[2][0,3]	['caesar','cobb','greek']
menu_array[0,2][0,3]	[ ['milk','coffee','tea'], ['ham','turkey',NULL] ]

Rename Saved Search

Table of Contents

Transformation Language Reference

Transformation Language Reference

Multidimensional Array

Multidimensional Array