ARRAY_GENERATE_SERIES

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Creates an array of sequential values within a range.

• <start>: The starting value of the sequence.
• <stop>: The ending value of the sequence (inclusive).

• <step>: The increment between values (defaults to 1).

• For date and timestamp data types, there is no default value, and the step is required.

Returns an array that contains sequential values from start to stop, incrementing by step.

Create an array of integers from 1 to 5.

Returns array[1, 3, 5], a sequence from 1 to 5 with step 2.

• Array Data Type
• GENERATE_SERIES