Data Grouping Table

The Data Grouping table displays in the bottom of the Main Canvas in the Data Loader window. It allows you to set up how data is grouped in the Project Tree. See how to Group Data for more information.

Data grouping is controlled in the Grouping section of the Configure the Loader Tab, but the grouping occurs by what you defined in the data grouping table.

Note: You can create groupings to any nesting level. However, after three levels groups can become difficult to manage, so it is advisable to limit the number of grouping levels to three, if possible.

The data grouping table has four columns.

  1. Grouping Column – The name of the column the group is formed from. This can also be a mapping type, such as <Assay>, in which case all columns that are mapped to this type are grouped.
  2. 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.
  3. Group Blanks – Creates a group entry for blank data. Use this if a blank value is a valid value, rather than missing data. This 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.
  4. Comment – Optional comment.