ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
latest (15.3.0) 15.2.0 15.1.0 14.5.x 13.9.x 13.8.x 13.7.x 13.6.x 13.5.0 13.4.x 13.3.x 13.2.x
User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Lookups in Rules

Create lookups in rules

During rule implementation, when you select is from catalog item` or is not from catalog item, a lookup item is generated.

There are some configuration options you need to define:

600

  1. Select the catalog item and attribute for which you would like the lookup to be built.

    600

  2. Click Select this attribute.

  3. Provide the following details for lookup creation:

    1. Duplicities handling:

      • First: One duplicated value is permitted for each value in the lookup item. The one allowed duplicate is the first occurrence of the duplicated value.

      • Omit: No duplicated values are accepted in lookup items.

      • Accept: All duplicates are accepted and there is no limit to the number of repeated values in a lookup item.

    2. Matching values:

      • Remove accents: If selected, removes all diacritic marks (accents).

      • Remove repeated characters: If selected, removes repeated characters.

      • Squeeze whitespaces: If selected, replaces repeated white space characters with a single space character.

      • Upper case: If selected, converts all words to upper case.

    3. Supported characters: Define the supported characters using the format [:letter:] [:number:].

      If defined, characters not contained in this set are removed or substituted. By default, all characters are supported ([:all:]).

    4. Substitute with: Define a string to substitute any unsupported characters, if you have defined specific supported characters in Supported Characters.

  4. Select Confirm. The lookup build starts automatically and produces the lookup file which is used in the rule.

    Lookup build will happen in the background – during this time you cannot publish or test the rule.

  5. On the rules screen, select Publish to publish and save the changes.

Your rule and lookup item have now been created. The lookup item is available in Data Quality > Lookup Items.

You can also utilize pre-existing lookups in rules by selecting is from reference data or is not from reference data.

Use lookups in rules

If you want to use an existing lookup in rule conditions, use the options is from reference data and is not from reference data.

Was this page useful?