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. In the summary view, click Edit.
The profile wizard appears
2. In the profile wizard, click Select Source.
3. In the Select Source screen, select the check box next to Name on the toolbar to clear all columns.
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 is selected.
6. Click Save and Run.
The profile results appear in the summary view.
7. Click the FirstName rule, the profile results for the rule appears in detailed view.
8. Select a value in the Values pane. Right-click on the value and click Drilldown.
The values for the FullName column and the FirstName and LastName rules appear in the Data Preview pane along with other column values. Notice that the Analyst tool separates the FullName column into first name and last name.