Task 2. View the Expression Rule Output
In this task, you view the output of expression rules that separates first and last names after you run a profile.
1. From the Actions menu, select Run Profile.
The Analyst tool runs the profile and displays the profile results.
2. From the Actions menu, select Column Profiling.
3. In the Columns section, select the check box next to Name on the toolbar to clear all columns.
You can see that one of the columns is selected by default because you need to select at least one column in the Columns section.
4. Select the FullName column and the FirstName and LastName rules.
5. Clear any other column that you see selected.
6. Click Save & Run.
7. In the profile results, click the FirstName rule.
The values appear in the Values tab in the right pane.
8. Select any value in the Values tab.
9. Right-click and select Drilldown.
The values for the FullName column and the FirstName and LastName rules appear in the Drilldown panel along with other column values. Notice that the Analyst tool separated the FullName column into first name and last name.