ARRAY_COMPACT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns an array with all NULL elements removed.

• <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.

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

• Array Data Type