Array add

Supported in: Batch, Faster, Streaming

Adds a value to the array at a specified index.

Expression categories: Array

Declared arguments

Array: The array to add an element to.
Expression<Array<T>>
Index: Position where the new element should be inserted into the array. First element is at position 1.
Expression<Integer>
Value: The element to add to the array.
Expression<T>

Type variable bounds: T accepts AnyType

Output type: Array<T>

Argument values:

Argument values:

numbers	value	index	Output
null	1	1	null
[ 1 ]	null	1	[ null, 1 ]
[ 1 ]	1	null	[ 1 ]

Description: Index values greater than the list length append to the array.

Argument values:

numbers	value	index	Output
[ 1, 2 ]	3	3	[ 1, 2, 3 ]
[ 1 ]	2	3	[ 1, null, 2 ]
[ ]	1	3	[ null, null, 1 ]
[ 3, 5 ]	1	10	[ 3, 5, null, null, null, null, null, null, null, 1 ]

Description: Negative values for the index count back from the end of the array.

Argument values:

numbers	value	index	Output
[ 1, 3 ]	2	-1	[ 1, 2, 3 ]
[ 2, 3 ]	1	-2	[ 1, 2, 3 ]
[ 2, 3 ]	1	-3	[ 1, null, 2, 3 ]
[ 2 ]	1	-1	[ 1, 2 ]
[ 2 ]	1	-2	[ 1, null, 2 ]
[ 2 ]	1	-3	[ 1, null, null, 2 ]
[ ]	1	-1	[ 1, null ]
[ ]	1	-2	[ 1, null, null ]
[ ]	1	-3	[ 1, null, null, null ]