Summarise fields  

The summarise fields operation allows you to create a "Summary" field that combines the values from one or more fields into a single field. 

 Options

• Fields. The field chooser you to select which fields from the input data will be included in the summary field.
• Show field names. This option sllows you to select which fields from the selections made in the field chooser include their names in the summary data.
• Summary field name. This option allows you to enter the name of the summary field.
• Summary field separator. Allows you to select the characters that are used to separate the values of each field in the summary data.
• Delete summary fields. If selected, the fields selected for inclusion in the summary data will be removed from the data-set. If unselected the fields will be retained.
• Include empty values. If selected, blank values will be included in the summary data. If un-selected blank values will be skipped.  

Example

The Summarise fields operation is useful when importing data-sets with a large number of fields. Trying to analyse such a data-set can be inefficient, particularly when the data-set also contains a large number of records. If these fields aren't required for analysis, but you still want to retain the data it may be beneficial to create a single summary field instead.

In this example we are importing a data-set that contains information about a set of employees in the company. A sample of this data is shown below.

This data contains some fields that are useful for analysis: Name, Date of birth and Position. The data also contains some fields that we don't need to analyse: Performance evalutation and Academic qualifications. We could simply remove these fields using a field organiser, but we still want to be able to view the data. In this scenario we could use the Summarise fields operation to create a single field containing the values from these fields. Doing so will improve the overall performance of Omniscope once we have loaded the data.

The DataManager configuration for this operation is shown below. 

Go Back to data-operations.