Values analysis results can be viewed in a grid, as thumbnails, and in graphs.
The grid view of a Values analysis contains the following data, depending on the options you selected.
|COLUMN||Group By Column Type||Columns are created only if the group parameter is specified. Multiple columns, if specified, are created or displayed as the column name. These columns contain the unique values that the group by column takes on.|
|xdb||VARCHAR (128)||Database that the variable for the values operation resides in, as specified by the database parameter.|
|xtbl||VARCHAR (128)||Table that the variable for the values operation resides in, as specified by the table parameter.|
|xcol||VARCHAR (128)||Variable that the values operation runs against, as specified by the column parameter.|
|xtype||VARCHAR (50)||The data type of this variable.|
|xcnt||FLOAT||The total number of occurrences of this variable.|
|xnull||FLOAT||Total number of rows where this variable takes a null value.|
|xunique||FLOAT||Total number of rows where this variable takes a unique value.|
|xblank||FLOAT||Total number of rows where this variable is blank.|
|xzero||FLOAT||Total number of rows where this variable is equal to 0.|
|xpos||FLOAT||Total number of rows where this variable has a positive value.|
|xneg||FLOAT||Total number of rows where this variable has a negative value.|
The Values Thumbnail view displays results as thumbnails grouped by database and table of all the possible graph generations per column.
The Values Analysis graph view displays a bar graph of the zero, null, unique, positive, and negative results for the selected columns