Distinct Composite Settings

If the data on which you are working has multiple records, for example for the same person, you can optimize the way in which the data is handled by creating a single composite, or aggregate, record to process.

Note: This tab is only available when you select Create a composite record for each group on the Settings tab.

Setting options for the Composite tab

Field. This column shows all fields, except key fields in the data model, in their natural sort order. If the node is not connected, no fields are shown. To sort the rows alphabetically by field name, click the column header. You can select more than one row using either Shift-click or Ctrl-click. In addition, if you right-click a field, a menu is displayed from which you can choose to select all rows, sort the rows by ascending or descending field name or value, select fields by either measure or storage type, or select a value to automatically add the same Fill with values based on entry to every selected row.

Fill with values based on. Select the value type to be used for the composite record for the Field. The available options depend on the field type.
  • For numeric range fields you can choose from:
    • First record in group
    • Last record in group
    • Total
    • Mean
    • Minimum
    • Maximum
    • Custom
  • For time or date fields you can choose from:
    • First record in group
    • Last record in group
    • Earliest
    • Most Recent
    • Custom
  • For string or typeless fields you can choose from:
    • First record in group
    • Last record in group
    • First alphanumeric
    • Last alphanumeric
    • Custom
In each case, you can use the Custom option to exercise more control over which value is used to fill the composite record. See Distinct Composite - Custom Tab for more information.

Include record count in field. Select this option to include an extra field in each output record, called Record_Count by default. This field indicates how many input records were aggregated to form each aggregate record. To create a custom name for this field, type your entry in the edit field.