Skip to main content

date_lookup

1. Description​

The Date Lookup Calculation Type is used to extract a date field from master file based on the key present in input file and master file.

2. Screen Configuration​

date_lookup_image

Here AccNum key is looked up from base input file and if it matches ProductCode from er_ir reference file, then pcode is assigned for AccOpenDate in output else default as_on_date value is taken.

Click ⬇️ to download the sample data.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type.
  • dervation
    • derivation_type: The calculation type used to derive this output field, which for lookup is "DATE LOOKUP".
    • req_fields
      • input_key: Field name from the input metadata / output config to be the key to do lookup in master file.
      • master_name: Name of the master file configured in input config.
      • master_key: Field name from the master metadata to be the key which needs to be looked up.
      • 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 found in master file.