ARRAY_DISTINCT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns an array with duplicate elements removed, preserving the first occurrence of each element.

1ARRAY_DISTINCT(<array>)

• <array>: The source array.

Returns an array that contains only unique elements, with the first occurrence of each element preserved.

• Keeps only the first occurrence of each duplicate element.
• Preserves the relative order of elements.

Get unique values from an array with duplicates.

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

Returns array[1, 2, 3], removing the duplicate 1 and keeping the first occurrence.

• Array Data Type