Rollup Table

This action creates a rollup table by specifying which column to group and what functions to perform for the remaining columns.

  • Field

    Description
  • Label

    A label to identify the action. This label appears under the Action name inside the Action box. If this field is left blank, the default value is “Untitled.”
  • Description

    A brief explanation of what this action does inside the sequence. This description appears as a tooltip when your cursor hovers over the Action box.
  • Fail Message

    A message that identifies potential issues that could happen with this action. This fail message will appear if the action fails when you try generating the sequence. If this field is left blank, the default error message built into the action appears.
  • Functions Tab
  • Column

    The column to apply the function to. This can be the column name
  • Function

    Select from the following functions: AS_IS, SUM, AVG, NAVG, MIN, MAX, COUNT, NCOUNT
  • Rollup Columns Tab
  • Rollup Columns

    Add the columns to roll up.