Creating rules for matching entity records

When you create rules for matching i2 Analyze records, you decide what information Analyst's Notebook uses to identify matches in the records on your chart.

Depending on how your system administrator has configured Analyst's Notebook, you might have a number of rules that are available as defaults. You can activate or deactivate these rules but you cannot amend them. You can also choose to create and edit your own rules. Match rules consist of:
  • A name and description.
  • An entity type, for example a Person.
  • The property or properties to use in setting conditions, such as Last Name.
  • An operator that sets the kind of comparison for the match, such as Exact match.
  • Refinements to ignore particular characters and white space, if required.
  • The minimum conditions that must be met to report a match.

For example, in your data the combination of Passport Number and Date of Birth, or Last Name might provide strong evidence of a Person match. You can create a rule that tells Analyst's Notebook to identify the records on the chart with the same values for these properties. The example match rule would be:

  • Entity type = Person
  • Match all:
    • Property type = Passport Number
    • Operator = Exact match
  • Match any:
    • Property type = Last Name
    • Operator = Exact match
    • Property type = Date of Birth
    • Operator = Exact match
Note: Analyst's Notebook maintains a separate set of match rules for each server. The rules that you create remain in the Rules Overview window until you delete them, or connect to a different server.
  1. Click the Analyze tab, and then in the Match group, click Find Matching Records.
    The Find Matching Records window opens.
  2. Click the Rules button, next to the Find Matches button.
    The Rules Overview window opens.
  3. Click the New rule button.
    All the entity types from your current schema are listed.
  4. Choose an option from the list, for example, Person.
    The New person rule window opens.
  5. Enter a name for your match rule in the Name field. You cannot create a rule without a name.
  6. Optional: Enter a description of your match rule in the 'Description' field.
  7. In the next column, if you want to create conditions that records must meet in order to match, click the Add a condition button Add condition button.
    The Add conditions window opens.
  8. Select a property type such as First Name and choose an operator for the condition. The default operator is Exact match. Click the drop-down menu arrow to select other options.
    OperatorDescription
    Exact match The search identifies property values in the records that are exact matches. For example, if your condition is set to the 'Last Name' property, your match sets only contain records whose last names match exactly.
    Match first characters The condition is met when the opening characters of the property values match each other. For example, enter the number '3' to match with the first three characters.
    Match last characters The condition is met when the closing characters of the property values match each other. For example, enter the number '5' to match with the last five characters.
    Equal to The condition is met when the property value matches the value that was specified.
    Note: You can choose the operator for property values that contain text. Some properties such as age, height, date of birth, and weight are set to Exact match and cannot be changed.
  9. Click the Refine condition button Advanced next to the arrow to make further refinements to the conditions.
    Your system administrator might have selected some default options for value handling, such as when to ignore white space. You can change the default selection to suit your own rules. A dot icon appears next to the Refine condition button Advanced to indicate when these refinements are modified.
  10. In the last column, you can apply a number of conditions of which at least one must be met. You specify these conditions and refinements in the same way as you did for the previous column.
  11. Click OK.
    Your rule appears in the list on the Rules Overview window along with a summary of your chosen conditions.
You might want to create more rules before looking for matches. The Duplicate option in the Rules Overview window is useful for creating rules to edit, rather than starting from the beginning. When you are ready to begin matching, activate the rules that you want to search with, click OK, proceed to the Find Matching Records window and click Find matches.