Array Slice ([start:end])

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns a subarray within specified bounds from an array.

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

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