Profiling a field
Campaign profiles a field when you select it in a list then click the Profile button. You can profile any field in any mapped data source. You can also profile derived fields.
1.
In the configuration window of a process that includes the Profile button, select the field that you want to profile.
2.
Click Profile.
The Profile Selected Field window opens.
Campaign profiles the data in the selected field. The categories and frequency counts update as profiling progresses.
*
To ensure that all categories are processed and counts are complete, wait until profiling is complete before you use the results.
When profiling is complete, the Profile Selected Field window shows the following information:
*
The list of values in the selected field, shown in the Category column, and the corresponding Count of IDs with that value.
*
Campaign organizes values by category, grouping them to create approximately equal-sized segments. The default maximum number of categories (distinct bins of values) for display is 25. You can change the maximum number of categories.
*
The Statistics pane on the right shows the total count of IDs and other details about the data for that field, including:
*
The number of NULL values found
*
The total number of categories, or values, for that field
*
Statistical values for the data including the mean, standard deviation, minimum, and maximum values.
*
Mean, Stdev., Min., and Max. are not available for ASCII fields. When you profile text fields, these values appear as all zeros.
Copyright IBM Corporation 2015. All Rights Reserved.