Skip to main content

range_lookup

1. Description​

The Range Lookup Calculation Type is used to extract a field from master file based on whether the input key is present betweeen the start and end key values.

2. Screen Configuration​

range_lookup_image

In the above image, if IntRate_2 is present in betweeen IntRate(included) and IntSpread(excluded) then BV value is mapped else default value is mapped.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type. .
  • derivation
    • derivation_type: The calculation type used to derive this output field, which for multikey lookup is "RANGE_LOOKUP".
    • req_fields
      • input_key: Field name from the input metadata to be the key to do lookup in master file.
      • master_name: Name of the master file configured in input config.
      • master_start_key: Starting master key.The input key value should be greater than or equal to this key's value.
      • master_end_key: Ending master key.The input key value should be lesser than or equal to this key's value.
      • is_start_key_inclusive: If true then it considers the master start key value also.
      • is_end_key_inclusive: If true then it considers the master end key value also.
      • master_value: Field name from the master metadata which needs to be derived.
      • default_value: Field name from input metadata or output config or constants metadata which needs to be derived when input key is not between the master start and end key values.