Skip to main content

RangeCheck

1. Description

The RangeCheck Derivation Type is used to verifie whether the value is within the allowed rannge.

2. Screen Configuration

range_check_image

For the scpecified column it will check if the value of that column lies between the min and max value provided in required fields.

3. Required Fields

  • name: Output Field Name.
  • data_type: Output Field Type. Possible values are: "String".
  • dervation
    • derivation_type: The calculation type used to derive this output field, which for concat is "CONCAT".
    • req_fields
      • col_name: Field names from the input metadata.
      • min_val: Minimum range value.
      • max_val: Maximum range value.