If the Group By Style on the analysis parameters tab is set to User specified, a Group By element may be dragged onto the empty node under the Group By Clause. If User specified is not checked, a warning is given when the Group By element is applied that the option will be automatically checked.
Columns and/or other expressions can be moved into the folder titled Expressions, leading to a comma-separated list of the generated SQL items. Some of the possibilities include:
- Input columns — Columns can be utilized directly to group by input columns.
- Output columns — Variable references (in the Other category) can be utilized to group by output columns.
- Numeric literals — Numeric literals can be utilized to group by output columns by positional number.
- Text literal — A single Text literal can be used to enter a comma separated list of input or output columns or positional numbers directly in a single element.
There are no special properties for the Group By element.