Choose Collapse Columns Dialog Box

Use the Choose Collapse Columns dialog box to define the rules for collapsing columns using the Collapse operator.

For more information, see Collapse.
Setting Description
Column to Collapse Categorical type column to collapse.
Aggregate Aggregate function to apply. Possible values:
  • count
  • max
  • min
  • sum
  • avg
  • fixed
Aggregation Column Column to aggregate.
Column Alias Name for the collapsed column's aggregated value.
Related reference