ARRAY_REMOVE_AT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns an array with the element at a specified position removed.

• <array>: The source array.
• <position>: The 1-based index of the element to remove.

Returns an array with the element at the specified position removed.

• Validate positions before use to avoid unexpected behavior with out-of-bounds values. If you provide a position out-of-bounds no array elements are removed.

Remove the element at index 2.

Returns array[1, 5, 3], removing the element at position 2.

• Array Data Type