List Functions

append()

Appends an element to the end of the list and returns the updated list.

with ["a", 1, 2] as myList
return append(myList, "b")

Result:

difference()

Returns the difference between two lists, generating a new list of elements found in the first list but not in the second. Duplicates are preserved.

with [1,2,2,3] as l1, [3,4,5] as l2
return difference(l1, l2)

Result:

head()

Returns the first element in a list.

with ["a", 1, 2] as myList
return head(myList)

Result:

intersection()

Returns the intersection of two lists, producing a new list of elements common to both. Duplicates are included.

with [1,2,3,3] as l1, [3,3,4,5] as l2
return intersection(l1, l2)

Result:

listContains()

Checks whether a specified element exists in a list, returning 1 for true and 0 for false.

with ["a", 1, 2] as myList
return listContains(myList, "b")

Result:

listUnion()

Returns the union of two lists as a new list containing elements from either input. Duplicates are removed.

with [1,2,2,3] as l1, [3,4,5] as l2
return listUnion(l1, l2)

Result:

reduce()

Performs a calculation iteratively using each element in a list. With a specified initial value, the defined calculation takes the first element of the list as input.

with [1,3,5] as myList
return reduce(_sum = 0, item in myList | _sum + item) AS listSum

Result:

size()

Returns the number of elements in a list.

with [1, 2, null, 3] as myList
return size(myList)

Result: