Task 2. View the Profile Results

1. In the Discovery workspace, click the header for the NULL column to sort the values.
Notice that the Address2, Address3, and City2 columns have 100% null values.
In Lesson 4, you create a custom profile to exclude these columns.
2. In the Name column in the left pane, click Full Name. The values for the column appear in the Values tab.
Notice that the first and last names do not appear in separate columns.
In Lesson 5, you create a rule to separate the first and last names into separate columns.
3. In the Name column in the left pane, click CustomerTier.
Notice that the values for the CustomerTier are not consistent.
In Lesson 6, you create a scorecard to score the CustomerTier values. In Lesson 7, you create a reference table that a developer can use to standardize the CustomerTier values.
4. In the Name column in the left pane, click State and then click the Patterns tab in the right pane.
Notice that 483 columns have a pattern of XX, which indicate valid values. Seventeen values are not valid because they do not match the valid pattern.
In Lesson 6, you create a scorecard to score the State values.