ARRAY_DISTINCT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

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

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

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

• Array Data Type