Documentation

    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.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    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.

    To match the series to your data, use 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.