These rules allow you to normalize or standardize your data based on a specific criteria.  Transform Rules are applied in the Brushr module but the rule itself must be defined in Supervisr.  

To Create a new rule, press the ADD RULE button. This will open the Rule Dialogue window, which consists of 3 sections.

  • The left hand-side of the screen allows users to specify a rule name and description and add fields to be used in a rule.
  • The Rules Designer section contains a list of optional blocks on the left that can be dragged into the designer work area on the right to build rules.
  • The Rule Preview window below displays the results of the rule with sample data.  

TIP: Any changes to the rule can be immediately observed in the Preview area. A flag next to the Rule Preview label will automatically display the validity of the current rule.

The following blocks are available in the Rules Designer:

  • Format
    • Change text case (UPPERCASE, lowercase and Proper Case)
    • Format phone number (E164, International, National or RFC3966).  Automatically detects Country based on a record
    • Format country (Full Name, Abbreviate to 2 letters or 3 letters) 
    • Format state (Full Name or Abbreviate to 2 letters).  Automatically detects Country based on a record
    • Format URL (Strip protocol, change to HTTP or HTTPS, strip www, strip trailing slash, strip hash)
    • Text replace (replace value with another value)
  • Logic
    • If/Else Do
    • Compare value (equals, not equal to, less than, greater than, less or equal, greater or equal, contains, does not contain, starts with, ends with)
    • And/Or
    • Is empty
    • Not
  • Values
    • Text
    • Boolean (True/False)
    • Empty
    • Number
  • Fields
    • Set field value to (assigns a value to the field the rule is applied to)
    • Field value (returns a value of the field the rule is applied to)
    • Specified field value (returns a value of the selected field)

Note: To activate transform rule, associate it to a field in a dataset. Learn more:
Transform Rule: Associate to a field in a dataset

Press SAVE to create the rule or Cancel to exit without saving.