ARRAY_COMPACT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns an array with all NULL elements removed.

1ARRAY_COMPACT(<array>)

• <array>: The source array.

Returns an array with all NULL elements removed.

• Removes only NULL elements, not empty strings or zero values.
• Non-NULL elements maintain their original order.

Remove all NULL values from an array.

1SELECT ARRAY_COMPACT(array[1, null, 2]) AS result;

Returns array[1, 2], with the NULL element removed.

• Array Data Type