Get started
Yandex DataLens

GET_ITEM

Written by

    Syntax

    GET_ITEM( array, index )

    Description

    Returns the element with the index index from the array array. Index must be any integer. Indexes in an array begin with one.

    Argument types:

    • array — Array of fractional numbers | Array of integers | Array of strings
    • index — Integer

    Return type: Depends on argument types

    Example

    GET_ITEM([array_field], 2)

    Data source support

    ClickHouse 19.13, PostgreSQL 9.3.