AV | Create a Rule Set

Data Quality Guide > Design > Rule Sets > Create a Rule Set

Was this helpful?

Create a Rule Set

There are two ways you can add a rule set:

• From the Create Rule Set page which is described in this section.

• From the Rules page, when creating a data profile. See Save Profile Rules as Rule Set.

To create a new rule set

1. Click Data Quality, Rule Sets, Create Rule Set.

The Create Rule Set page is displayed. It is a guided workflow that lets you create a new rule set by specifying the rule set details and defining the rules.

2. Provide a description for the rule set:

• Name - Specify a unique name for your rule set.

• Locale - Select a language (country) preference. Locale will help in validating and applying rules like Is Valid Phone Number, Is Valid Social ID, and Is Valid Zip Code. If English (United States) locale is selected then United States phone number, social ID, zip code format will be used for validating. Default is English (United States). The available values are:

– English (Canada)

– English (Germany)

– English (India)

– English (United Kingdom)

– English (United States)

• Description - (Optional) Add a description text for the rule set.

3. Click Continue.

The Create Rule Set page is displayed. A blank new rule collection entry is displayed on this page, which you can edit to create a new rule collection.

4. Select a Data Type.

You can choose from Bigint, Binary, Boolean, Date, Decimal, Double, Float, Integer, Smallint, String, Table, Time, Time Stamp, and Tinyint. Based on the data type you select, a set of rules to choose from will appear. The data type also determines which fields the rule collection can be applied to.

5. Specify a Field Name Pattern.

The field name pattern represents the specified value used to identify similarly named fields in the source dataset. To enable field name pattern matching, add an asterisk (*) as a wildcard before or after the field name pattern value. This allows for matching similar field names.

Note:
- A Rule Collection name is automatically generated based on the specified Data Type and Field Name Pattern. The format is <DataType>_<FieldNamePattern>.
- The Field Name Patterns are case insensitive.

6. Select the Rules that you want to add to your Rule Collections.

Depending on the selected Data Type, a set of rules is available for you to choose from. You may have to specify additional parameters for some of the rules. Click the rule name below to see the rule details.

• Bigint - Compare to Constant, Is Not Null, Value in Range.

• Boolean - Is Not Null, Value in Range.

• Date - Compare to Constant, Is Not Null, Value in Range.

• Decimal - Compare to Constant, Is Not Null, Value in Range.

• Double - Compare to Constant, Is Not Null, Value in Range.

• Float - Compare to Constant, Is Not Null, Value in Range.

• Integer - Compare to Constant, Is Not Null, Value in Range.

• Smallint - Compare to Constant, Is Not Null, Value in Range.

• String - Compare to Constant, Is Not Blank, Is Not Duplicate, Is Not Null, Is Numeric, Is Valid Date, Is Valid Email, Is Valid Ip4, Is Valid Phone Number, Is Valid Social ID, Is Valid Time, Is Valid TimeStamp, Is Valid Zip Code, Matches Pattern.

• Time - Compare to Constant, Is Not Null, Value in Range.

• Time Stamp - Compare to Constant, Is Not Null, Value in Range.

• Tinyint - Compare to Constant, Is Not Null, Value in Range.

7. Click Add.

The new rule collection is added with the specified details.

Note: A new blank rule collection is created using which you can add another collection of rules.

You can also perform the following actions:

Icon	Description
	This icon is displayed next to each rule collection. Click this to Delete the corresponding rule collection from rule set.
	Click this icon to view the selected list of rules for the selected rule collection.

8. Click Save.

The new Rule Set is added. You can edit the rule set later from the Edit Rule Set page. See Edit a Rule Set.

Last modified date: 10/30/2024