ARRAY_PREPEND

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Inserts a value at the start of an array.

1ARRAY_PREPEND(<value>, <array>)

• <value>: The value to insert at the start of the array. The value must match the array element type.
• <array>: The array to prepend to.

Returns an array with the new value inserted at the beginning.

• Prepending NULL changes the array element type to nullable.

Add a value to the front of an array.

1SELECT ARRAY_PREPEND(1, array[2, 3, 4]) AS result;

Returns array[1, 2, 3, 4], with 1 inserted at the beginning.

Add a NULL value to the front of an array.

1SELECT ARRAY_PREPEND(null, array[2, 3, 4]) AS result;

Returns array[null, 2, 3, 4]. Prepending NULL to an array with a non-nullable element type changes the resulting element type to nullable.

• Array Data Type