This action creates a rollup table by specifying which column to group and what functions to perform for the remaining columns.
-
FieldDescription
-
LabelA 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.”
-
DescriptionA 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 MessageA 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
-
ColumnThe column to apply the function to. This can be the column name
-
FunctionSelect from the following functions: AS_IS, SUM, AVG, NAVG, MIN, MAX, COUNT, NCOUNT
- Rollup Columns Tab
-
Rollup ColumnsAdd the columns to roll up.