Data Grouping Window

The Data Grouping window allows you to quickly create a hierarchy of grouped data components (see Group Data). The library provides the most common groupings, but allows you to customise and add new grouping entries.

The Data Grouping window contains two tables that define data grouping settings.

  1. Grouping Entry table – Located at the top of the Main Canvas. Shows the grouping types that have been created. Some default grouping types display here. The entries in the Grouping Entry table are available from the Data Loader Component's Grouping Name option.
  2. Grouping Definition table – Located at the bottom of the Main Canvas. Shows the settings for the grouping type selected in the Grouping Entry table.

Grouping Entry table

The Grouping Entry table has the following columns.

  • Name – Name of the grouping entry. These names are used when you select a data grouping entry (for example, when loading data).
  • Comment – Optional comment.

Note: Each data grouping entry can have multiple grouping definitions, each on a new row in the Grouping Definition table.

Grouping Definition Table

The Grouping Definition table has the following columns.

  • Name – List of the entries from the Grouping Entry table.
  • Group By Mapping Type – Whether to group the data by mapping type (selected in the Mapping Type column)or a specified column.
  • Module – Module in which the mapping type is defined.
  • Mapping Type – Column data mapping type. Only available if Group By Mapping Type is checked.
  • Group Blanks – Whether to create a group entry for blank data. Only use if a blank field is a valid value, otherwise blank fields are treated as missing data. Only available if Group By Mapping Type is checked.

    Note: The Group Blanks cell is enabled only for non-numeric data if the No Value setting in the Column Definition Table is Default and the associated default setting has been left blank.

  • Grouping Column – Column to group on. Only available if Group By Mapping Type is unchecked.
  • Condition – An optional condition to filter or organise the grouping. Filters can be one of the following.
    • Blank – Leave the condition blank to create a group for each unique value found in a domain column, or a group of one if it is a non-domain column.
    • Separate Values – Use a comma (,) or a semi-column (;) to separate values to create group entries for the specified values only. In other words, use this if you do not want to create group entries for all unique values found in categorical data. For example, entering Au,Cu creates entries only for these two columns and not for any other columns.
    • Start, End and Width – For numeric data you can create numeric groups by using the <start>-<end>:<width> format to create group entries for each bin. For example, entering 0-60:20 creates a data component entry for values between 0–20, between 20–40, and between 40–60.
    • Greater Than and Less Than – Use the * character in combination with the start and end value, like 0*–60*:20, to make the first bin less than the start value and the last bin greater than or equal to the end value. In this example, the resulting categories are less than or equal to 0, 0–20, 20–40, 40–60, and greater than or equal to 60.
  • Comment – Optional comment.