ARRAY_REMOVE

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns a new array with all instances of a specified element removed.

1ARRAY_REMOVE(<array>, <element>)

• <array>: The source array.
• <element>: The value to remove.

Returns an array with all occurrences of the specified element removed.

• Removes all occurrences of the element, not just the first.
• If the element isn’t found, the original array is returned unchanged.

Remove all instances of a value from an array.

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

Returns array[2, 3], removing both occurrences of 1.

• Array Data Type