Sequence

  • Published on Jan 6, 2023
  • 1 minute(s) read
Prev Next

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

Setting Description\Parameters
Split Columns The selected column(s) will be used to split the data set over when calculating summary metrics.
Sequence Column Actuals data column.
Mode Determines whether the sequence is numeric in nature or based on 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 define 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 define value provided in the Custom Value setting.

Column Fill Options

Setting Description\Parameters
Column Name Name of the column you would like 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 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 Value When valid, this is the specific fill value used.

Actions

Action Description
Preview After configuring the node, the combined result set can be previewed by clicking the Preview button.