arrayAppend

Description

Returns a new array with an additional element appended to the end of an existing array.

• The element type must match the array type.
• Supported element types include string, bool, number, interval, timestamp, regexp, and enum.

Syntax

Like many functions in DataPrime, arrayAppend supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.

Function notation

arrayAppend(array: array<T>, element: T): array<T>

Method notation

(array: array<T>).arrayAppend(element: T): array<T>

Arguments

Name	Type	Required	Description
array	array<T>	true	The base array to modify
element	T	true	The element to append, must match the array type

Example

Use case: Add a missing value to an array for consistency in processing

Suppose you have an array of job names but need to include an additional value from another field. Consider the following input:

{
    "my_values": ["Job 1", "Job 2", "Job 3"],
    "my_other_value": "Job 4"
}

By appending my_other_value to my_values, you can ensure all values are included in the array for downstream processing.

Example query

Function notation

replace my_values with arrayAppend(my_values, my_other_value)

Method notation

replace my_values with my_values.arrayAppend(my_other_value)

Example output

The result will include the new element at the end of the array:

{
    "my_values": ["Job 1", "Job 2", "Job 3", "Job 4"],
    "my_other_value": "Job 4"
}