---
title: "Generate a date or number sequence in Strata | Oplema"
description: "Create a table of evenly spaced dates or numbers in Strata, such as one row for every day of a month, without any input table."
url: "https://oplema.com/docs/strata/io/sequence"
updated: "2026-11-04"
---

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

**Learn this in context:** [Fill missing dates and calculate a 7-day average](https://oplema.com/learn/table-to-dashboard/fill-missing-dates) (Build and publish a dashboard)

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

Result
| date |
| --- |
| 2025-03-01 |
| 2025-03-02 |
| 2025-03-03 |
| 2025-03-04 |
| 2025-03-05 |
| 2025-03-06 |
| 2025-03-07 |

1. Look at the preview. It shows seven rows, from 2025-03-01 to 2025-03-07.
2. Change Every to `2`. The preview shows four rows: the 1st, 3rd, 5th and 7th.
3. Change the second Stop setting (`Inclusive`/`Exclusive`) to `Exclusive`. 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](https://oplema.com/docs/strata/transform/expand-rows).

To match the series to your data, use [Join](https://oplema.com/docs/strata/combine/join).

## Inputs and outputs

### Inputs

0 ports

No 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: `Dates`

Options: 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: `day`

Options: 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: `Inclusive`

Options: 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.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
