Distinct Composite - Custom Tab

The Custom Fill dialog box gives you more control over which value is used to complete the new composite record. Note that must instantiate your data first before using this option if only customizing a single Field row on the Composite tab.

Depending on the field type, you can choose from one of the following options.

• Select by frequency. Choose a value based on the frequency with which it occurs in the data record.
  Note: Not available for Fields with a with a type of Continuous, Typeless, or Date/Time.
  • Use. Select from either Most or Least Frequent.
  • Ties. If there are two or more records with the same frequency of occurrence, specify how to select the required record. You can choose from one of four options: Use First, Use Last, Use Lowest, or Use Highest.

• Includes value (T/F). Select this to convert a field to a flag which identifies if any of the records in a group has a specified value. You can then select the Value from the list of those for the selected field.
  Note: Not available if you select more than one Field row on the Composite tab

• First match in list. Select this to prioritize which value to give to the composite record. You can then select one of the Items from the list of those for the selected field.
  Note: Not available if you select more than one Field row on the Composite tab

• Concatenate values. Select this to retain all the values in a group by concatenating them into a string. You must specify a delimiter to be used between each value.
  Note: This is the only option available if you select one or more Field rows with a type of Continuous, Typeless, or Date/Time.
• Use delimiter. You can choose to use a Space or Comma as a delimiter value in the concatenated string. Alternatively, in the Other field, you can enter your own delimiter value character.
  Note: Only available if you select the Concatenate values option.