Data Quality Getting Started Guide

10.5
- 10.5.6
- 10.4.0

Back Next

Task 4. View Column Profiling Results

In this task, you view the column profiling results for the All_Customers data object and examine the values and patterns contained in the data.

Click

Window

Show View

Progress

to view the progress of the All_Customers profile.

The Progress view opens.

When the Progress view reports that the All_Customers profile finishes running, click the

Results

view in the editor.

In the

Column Profiling

section, click the

CustomerTier

column.

The

Details

section displays all values contained in the CustomerTier column and displays information about how frequently the values occur in the data set.

In the

Details

section, double-click

Ruby

The Data Viewer runs and displays the records where the CustomerTier column contains the value

Ruby

In the

Column Profiling

section, click the

OrderAmount

column.

In the

Details

section, click the

Show

list and select

Patterns

The

Details

section shows the patterns found in the OrderAmount column. The string

9(5)

in the Pattern column refers to records that contain five-figure order amounts. The string

9(4)

refers to records containing four-figure order amounts.

In the

Pattern

column, double-click the string

9(4)

The Data Viewer runs and displays the records where the OrderAmount column contains a four-figure order amount.

In the

Details

section, click the

Show

list and select

Statistics

The

Details

section shows statistics for the OrderAmount column including the average value, standard deviation, maximum and minimum lengths, the five most common values, and the five least common values.

Rename Saved Search

Table of Contents

Data Quality Getting Started Guide

Data Quality Getting Started Guide

Task 4. View Column Profiling Results

Task 4. View Column Profiling Results