Contents x
    Sequence
    • 13 Jan 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Sequence

    • Updated on 13 Jan 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    Description

    The Sequence node completes a sequence of rows. It can add rows to fill gaps in numeric data and do the same for date-based data.


    Configuration Options

    Basic Configuration Options

    SettingDescription\Parameters
    Split ColumnsThe selected columns split the data set over when calculating summary metrics.
    Sequence ColumnTarget data column.
    ModeDetermines whether the sequence is numeric in nature or based on the date format.

    Options
    • Numeric
    • Date
    Date GranularityWhen Date is selected for the Mode setting above, this field specifies the date format used.

    Options
    • Day (YYYYMMDD format)
    • Week(YYYYMMW format)
    • Month (YYYYMM format)
    • Quarter (YYYY'Q'Q format e.g., 2010Q1)
    • Year (YYYY format)
    Sequence StartIndicates the strategy used for the first value in the sequence.

    Options
    • Occurrence - Uses the first value found in the Sequence Column for the defined Split Columns.
    • Global Minimum - Uses the minimum value found in the Sequence Column across all the input data.
    • Global Maximum - Uses the maximum value found in the Sequence Column across all the input data.
    • Custom - Uses the custom defined value provided in the Custom Value setting.
    Sequence EndIndicates the strategy used for the last value in the sequence.

    Options
    • Occurrence - Uses the last value found in the Sequence Column for the defined Split Columns.
    • Global Minimum - Uses the minimum value found in the Sequence Column across all the input data.
    • Global Maximum - Uses the maximum value found in the Sequence Column across all the input data.
    • Custom - Uses the custom defined value provided in the Custom Value setting.

    Column Fill Options

    SettingDescription\Parameters
    Column NameName of the column to populate with a value.
    Value TypeIndicates the strategy used for the last value in the sequence.

    Options
    • Occurrence - Uses the prior row's value found in the Column Name column.
    • Custom - Uses the custom defined value provided in the Custom Value setting.
    • Increment - Uses the last value of the Column Name column and increments it by the Custom Value amount.
    • Decrement - Uses the last value of the Column Name column and decrements it by the Custom Value amount.
    Custom ValueWhen valid, this is the specific fill value used.

    Actions

    ActionDescription
    PreviewOnce the node is configured, the combined result set can be previewed at any time.
    Was this article helpful?
    What's Next