Data Profiling

Back Next

Compare column results

When you compare the results for two or more columns in a profile run, the comparison results appear on the

Compare Columns

tab. Each column statistic appears in a row. You can add or delete columns on the

Compare Columns

tab.

The following sample image shows the

Compare Columns

tab:

The

Compare Columns

area shows the following results in collapsible sections:

Metrics: Shows column statistics, such as the value distribution, percentage and number of values, and the minimum and maximum values.
Data Types: Shows the percentages of documented data type and inferred data types in separate rows.
Patterns: Shows the percentages of inferred patterns in separate rows.
Most Frequent Values: Shows the percentages of all the values and their frequencies in a column in separate rows.; Sometimes, the Most Frequent Values
might not display all the available values in a column when the number of most frequent values in a column is greater than the Maximum Number of Value Frequency Pairs
value. To view all the available values, increase the Maximum Number of Value Frequency Pairs
value as necessary.