Sequence
Sequence creates a table of evenly spaced dates or numbers without any input. Use it to get one row for every day, week or month, including periods your data has no rows for.
Generate a week of dates
Sequence is set to Dates, from 2025-03-01 to 2025-03-07, one day at a time. It has no input, and its preview shows seven rows in a date column.
Sequence interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| date |
|---|
| 2025-03-01 |
| 2025-03-02 |
| 2025-03-03 |
| 2025-03-04 |
| 2025-03-05 |
| 2025-03-06 |
| 2025-03-07 |
- Look at the preview. It shows seven rows, from 2025-03-01 to 2025-03-07.
- Change Every to
2. The preview shows four rows: the 1st, 3rd, 5th and 7th. - Change the second Stop setting (
Inclusive/Exclusive) toExclusive. The 7th lands on the stop date and is dropped, leaving three rows.
When to use
Use Sequence when you need rows that don't exist yet, such as a calendar of every day in a quarter. Join it to your data to reveal the days with no sales, then fill them with Interpolation. To create a range for each row of an existing table, use Expand Rows.
To build a range for each row of a table, use Expand Rows.
To match the series to your data, use Join.
Inputs and outputs
Inputs
0 portsNo input ports
This block has no incoming connection.
Outputs
1 port- Out
Configure the block
- Kind
Generate a date spine or a numeric range.
Default:
DatesOptions: Dates, Numbers.
- Start
First date in the series.
- Stop
Last date in the series. The second Stop setting (Inclusive/Exclusive) decides whether a date landing on it is kept.
- Every
Step size, combined with the unit.
Default:
1- Unit
Calendar unit for the step. Month, quarter and year clamp to the end of shorter months.
Default:
dayOptions: day, week, month, quarter, year.
- Start
First value in the series.
Default:
1- Stop
Last value in the series. The second Stop setting (Inclusive/Exclusive) decides whether a value landing on it is kept.
Default:
10- Step
Increment between values; must be greater than zero.
Default:
1- Stop
Inclusive keeps the stop value when it lands on the series; Exclusive always drops it.
Default:
InclusiveOptions: Inclusive, Exclusive.
- Column Name
Name of the produced column; leave empty for date (dates) or n (numbers).
Sequence FAQs
- Does Sequence need an input table?
- No. It creates its rows from its own settings, so it can start a flow.
- What does Exclusive do?
- It drops the stop value when the series lands on it. Inclusive keeps it.
- What happens with months of different lengths?
- Month, quarter and year steps use the end of a shorter month when the date doesn't exist in it.
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.