Adding and modifying rules for the Standardization Rules Designer product tutorial

In this module, you will add and modify rules to ensure that records for new retail product data are standardized correctly.

The fictional Sample Outdoor Company wants to add or modify rules so that the records from their new product lines are handled properly. To do so, it will use the new custom class and lookup table that were created earlier in the tutorial.

First, the company looks at the rule that handles the most common pattern in the data. The records that match this pattern are handled relatively well, but some products require that the product name include the product brand name. The rule must be modified to ensure that the product names for some products include the product brand name.

Next, the company looks at the second most common pattern in the data, B+S+CT, which is not handled at all. The company must add a rule to handle this data. This rule will convert the product color to product color code by using the lookup table that was added to the Standardization Rules Designer.

When the company looks at the remaining unhandled patterns, the company finds a pattern in which unit of measure and amount are concatenated into one value. For example, the values 195 and CM are concatenated into 195CM. The company adds a rule for this pattern that splits the data into the appropriate output columns.

After rules are added and modified, the company decides update the actual rule set by publishing the revision.

Learning objectives

After completing the lessons in this module you will understand the concepts and tasks for adding and modifying rules and publishing revisions:

Modify a rule
Identify unhandled patterns and view example records for those patterns
Customize the output columns that are available in the Standardization Rules Designer
Add a basic rule by mapping values in a record to the appropriate output columns
Add actions that reference a lookup table
Add a rule that splits a concatenated value into two distinct values
Publish a revision

Time required

This module takes approximately 60 minutes to complete.

Prerequisites

Ensure that you completed the setup steps and have the tutorial files and sample data loaded on your computer system.
Complete Module 2, which includes creating the unit of measure custom class.
Complete Module 3, which includes adding a lookup table that converts product colors to numeric color codes.

Module 4: Adding and modifying rules

Learning objectives

Time required

Prerequisites

Lessons in this module