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

    Sequence

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

    Description

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


    Configuration Options

    Basic Configuration Options

    SettingDescription\Parameters
    Split ColumnsThe selected column(s) will be used to split the data set over when calculating summary metrics.
    Sequence ColumnActuals data column.
    ModeDetermines whether the sequence is numeric in nature or based on 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 define 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 define value provided in the Custom Value setting.

    Column Fill Options

    SettingDescription\Parameters
    Column NameName of the column you would like 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 define value provided in the Custom Value setting.
    • Increment - Uses the the last value of the Column Name column and increments it by the Custom Value amount.
    • Decrement - Uses the 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
    PreviewAfter configuring the node, the combined result set can be previewed by clicking the Preview button.
    Was this article helpful?
    What's Next