Field Values H
Field Values V
Use this page to view the unique values for the selected field while viewing table field results.
To access this page to view details about a specific table:
- Select Common > Analyze in the Navigation pane.
- Click the Profile icon for a data source.
- Click the Tables icon.
- Click the Fields icon for a table.
- Click the Unique Value List icon for a field.
Field | Description |
COUNTER | Displays the order in which records are loaded into the table. |
FIELD NAME | Displays the name of field containing unique values. |
TABLE | Displays the table containing field with unique values. |
UNIQUE VALUE | Displays the unique value for the Field Name. |
UNIQUE VALUE COUNT | Displays the number of occurrences of the unique value. |
Field Values V
Field | Description |
Table | Displays the table containing the field with unique values. |
Field Name | Displays the name of field containing unique values. |
Unique Value | Displays the unique value of the Field Name. |
Unique Value Count | Displays the number of occurrences of the unique value. |
Field Datatype | Displays the type of field. |
Blank Value Count | Displays the number of blank values in the table. |
Min Value | Displays the value of smallest value in the table. |
Max Value | Displays the value of largest value in the table. |
Max Field Length | Displays the length of the longest field in the table. |
Unique Flag | Displays a message if the 1000 unique value limit is hit, i.e., there are more than 1000 unique values in the column. If the limit needs to be increased, update the Unique Cache Row Limit field under Configuration > Modules > Parameters-Profile. |
Field Defined Length | Displays the defined DBMS length for the field. |
Field Defined Order | Displays the order in which the field displays in the table. |
Processing Message | Displays the current field process. The field is blank if there are no errors or messages from the processing job. |
Added By | Displays User ID of the individual who ran the unique process. |
Added On | Displays the date the unique process was run. |
Changed By | Displays User ID of individual who changed the Interesting setting, which is configured on theTable Field (Results) page. |
Changed On | Displays the date when the Interesting setting was changed. |
Counter | Displays the order in which records are loaded into the table. |
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.