Data Profiling

Back Next

Compare run results

When you compare the results for two profile runs, the comparison results appear on the

Compare Runs

tab.

The following sample image shows the areas that you can view on the Compare Runs
tab:

Header

Filter or find

Compare statistics

Details

Header

The header area shows the profile run details which include the profile run numbers, profile run timestamps, and number of rows in the earlier run as compared to the later run.

Filter or find

The following table explains the options that appear in the Filter and find
area:

Option	Description
View	Shows the following options: Columns and Rules. View the results for all the columns and rules in the profile run. Columns. View the results for the columns in the profile run. Rules. View the results for the rules in the profile run.
With	Shows the following options: Compare All Runs. View the comparison results for both the runs. Differences. View the differences in results in both the runs. Matches. View the results that match in both the runs. Added. Vew the results for columns that was added in the later run. Removed. View the results for columns that was removed in the later run. Choose a filter in the With option after you choose a filter in the View option.
Find	Enter a keyword to view the relevant search results.
Menu	Choose Comfortable, Cozy, or Compact to adjust the row width in the profile results area.

Compare statistics

The compare statistics area shows the columns and rules in collapsible sections. The column statistics in both the runs are compared and displayed in the compare statistics area. An up arrow with a numeric count displays an increase in value for the statistic from the earlier run to later run. A down arrow with a numeric count displays a decrease in value for a statistic. You can choose the statistics that you want to view in the area. To add or remove a statistic, right-click a statistic name and select or clear the statistic.

The following sample image shows the compare statistics area:

The image shows a sample compare statistics area where four columns are compared and the statistics for each column is displayed.

The compare statistics area shows column statistics, such as the value distribution, percentage and number of values, data types, patterns, and the minimum and maximum values.

When you click a column, the statistics for the column appear in the

Details

area for the later run.

Details

In the

Details

area, you can view the statistics and comparison results. The comparison results include the number of rows in both the runs, difference in row count and row percentage in the later run.

The following sample image shows the Details
area:

The sample image shows the details area where the values, data types, and patterns section shows sample values.

In this area, you can view the following statistics in collapsible sections:

Values in <later_run>: Shows the comparison results for null values, distinct values, and non-distinct values.
Data Types in <later_run>: Shows the comparison results for inferred data types.
Patterns in <later_run>: Shows the comparison results for inferred patterns.