Search results

    Edit on GitHub

    CONCAT

    Concatenates all values into a single string, separated by the separator

    Properties

    • Separator - String to use as a separator between elements
    input Separator result
    "a", "b", "c" ", " "a, b, c"
    5.5 ", " "5.5"
    "a", "b", "c" "" "abc"

    COUNT

    Returns the amount of items in a given array

    input result
    0
    "a", "b", "c" 3

    DISTINCT

    Get all the distinct elements in the array

    input result
    1, 2, 3, 4, 4, 1 1, 2, 3, 4

    ELEMENT_AT

    Gets the element at the given index in the array

    Properties

    • Index - The index of the item to return
    input Index result
    "a", "b", "c" 1 "b"
    "a" 1 null
    "a", "b", "c" -1 null

    FIRST

    Gets the first element in the array

    input result
    null
    "a", "b", "c" "a"

    LAST

    Gets the last element in the array

    input result
    null
    "a", "b", "c" "c"

    SUM

    Sums all the values in the array

    value result
    1, 0.2, 30 31.2