Skip to main content

lookup

1. Description​

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

2. Screen Configuration​

lookup_image

Here If AccNum from base input file matches with cid of cust_grp reference file then CustomerGroupId from reference file is assigned to GLCode else default value NA is assigned.NA should be declared in additional derivatives.

Click ⬇️ to download the sample data.

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 lookup is "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.