Skip to content

Sequence

Last updated: 13 Jan 2023

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

Setting Description\Parameters
Split Columns The selected columns split the data set over when calculating summary metrics.
Sequence Column Target data column.
Mode Determines whether the sequence is numeric in nature or based on the date format.

Options

  • Numeric
  • Date
| |Date Granularity|When 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 Start|Indicates 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 End|Indicates 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

Setting Description\Parameters
Column Name Name of the column to populate with a value.
Value Type Indicates 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 Value When valid, this is the specific fill value used.


Actions

Action Description
Preview Once the node is configured, the combined result set can be previewed at any time.