Creating Expression Rules Overview
Expression rules use expression functions and source columns to define rule logic. You can create expression rules and add them to a profile in the Analyst tool. An expression rule can be associated with one or more profiles.
The output of an expression rule is a virtual column in the profile. The Analyst tool profiles the virtual column when you run the profile.
You can use expression rules to validate source columns or create additional source columns based on the value of the source columns.
Story
HypoStores wants to incorporate data from the newly-acquired Los Angeles office into its data warehouse. HypoStores wants to analyze the customer names and separate customer names into first name and last name. HypoStores wants to use expression rules to parse a column that contains first and last names into separate virtual columns and then profile the columns. HypoStores also wants to make the rules available to other analysts who need to analyze the output of these rules.
Objectives
In this lesson, you complete the following tasks:
- 1. Create expression rules to separate the FullName column into first name and last name columns. You create a rule that separates the first name from the full name. You create another rule that separates the last name from the first name. You create these rules for the Profile_LA_Customers_Custom profile.
- 2. Run the profile and view the output of the rules in the profile.
- 3. Edit the rules to make them usable for other Analyst tool users.
Prerequisites
Before you start this lesson, verify the following prerequisite:
- •You have completed Lessons 1 through 4.
Timing
Set aside 10 to 15 minutes to complete this lesson.