Skip to content

Predefined Value

The Predefined Value rule refers checks for the correct usage of lookup operations within a system. A Predefined Value check operation involves searching for a value in a predefined set or dataset (like a table or array) based on a key or criterion.

Rule configuration

The Rule configuration for Predefined Value ensures data validation by comparing it against predefined static values stored in a reference table. The check can be case-sensitive, meaning it differentiates between uppercase and lowercase letters to maintain accuracy and consistency in data matching and validation processes.

Static values static values refer to predefined, unchanging values used in the process of validating and matching data. These static values are often stored in a reference or lookup table and are used to ensure that the data meets certain consistency or correctness criteria.

Case-sensitive Case sensitivity refers to whether the comparison between the value being looked up and the static reference values is sensitive to the difference between uppercase and lowercase letters.

Success criteria

Success criteria for a Predefined Value check in data quality are typically defined by its ability to accurately match values from a static reference dataset to the source data, ensuring consistency and correctness. The key indicators of success include high match rate (i.e., the percentage of source data that can be successfully mapped to a reference value), minimal false positives (incorrect matches), low error rates (such as missing or unmatched data), and the efficient handling of exceptions.

  • The success condition depends on how the Static Values is configured.
  • The success condition is met if this count satisfies the given operator and value.
  • For example, if the column contains an input such as Mango that exactly matches the static value Mango, it will pass. Otherwise, inputs like pineapple, or if case sensitivity is enabled mango, will also fail.

Configuration fields

  • Operator options

    Greater than

    Less than

    Equal to

    Between (requires specifying a start and end range)

  • Operator Defines the comparison operation (Greater Than, Less Than, Equal To, or Between).

  • Value The threshold value used for success criteria. Required for Greater than, Less than, and Equal to operators.

  • Value range Required only when the Between operator is selected, specifying the start and end range.

  • Threshold type Indicates whether the Value or Value Range to be considered as percentage or an absolute count.

  • Allow null values Determines if null values are permitted.

  • Check for match Determines if data values align with predefined standards, formats, or reference values to ensure accuracy, consistency, and integrity

Sample Input

IDVegetablesFruits
1TomatoPineapple
2Lettuceapple
3CarrotMango
4OnionApple
5broccoliBanana

Sample rule configuration

  • Static values Vegetables = Tomato,Onion,Broccoli, Fruits = Apple,Banana,Mango,Pineapple
  • Case sensitivity True

Sample success criteria configuration

  • Operator Less than
  • Value 4
  • Threshold type Absolute Count
  • Allow null values False
  • Check for match False

alt text

Sample Output

Column NameRule NameSuccess CountFailure CountWithin ThresholdNull Count
VegetablesPredefined Value check23Yes0
FruitsPredefined Value check41No0