Array Slice ([start:end])

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns a subarray within specified bounds from an array.

1(<ARRAY>)[<start>:<end>]

• <array>: The array to slice.
• <start>: The starting index.
• <end>: The ending index.

Returns an array that contains elements from the start index to the end index (inclusive).

• Both bounds are inclusive and 1-based.
• If bounds exceed the array length, the result is limited to available elements.

Extract elements from index 2 to 3.

1SELECT (ARRAY[1, 2, 3])[2:3] AS subarray;

Returns [2, 3], a subarray containing the elements at positions 2 and 3.

• Array Data Type