Task 1. Create Expression Rules and Run the Profile
In this task, you create two expression rules to parse the FullName column into two virtual columns named FirstName and LastName. The rule names are FirstName and LastName.
1. Verify that you are in the Discovery workspace.
You can see the profile results for the profile Profile_LA_Customers_Custom.
2. From the Actions menu, select Edit > Column Profiling Rules.
The Edit Profile dialog box appears.
3. Click + to create a rule.
4. Select Create a rule.
5. Click Next.
6. In the Name field, enter FirstName.
7. In the Expression section, enter the following expression to separate the first name from the Name column:
SUBSTR(FullName,1,INSTR(FullName,' ' ,-1,1 ) - 1)
8. Click Validate.
9. Click OK.
10. Click OK to go back to the Column Profiling Rules panel.
11. Click Save.
The Analyst tool creates the rule.
12. Scroll down to the bottom of the Column Profiling panel to view the rule details.
13. Repeat the previous steps to create a rule named LastName and enter the following expression to separate the last name from the Name column:
SUBSTR(FullName,INSTR(FullName,' ',-1,1),LENGTH(FullName))