Skip to main content

matrix_lookup

1. Description​

The matrix Lookup Calculation Type is used to extract a field from master file based on the column and row key.

2. Screen Configuration​

mat_lookup_image

In the above image, It checks for the value present in the SalaryFlag1 row in AccNum1 column in master file and the corresponding value is stamped.

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 input mapping is "MATRIX_LOOKUP".
    • req_fields
      • row_key: Field representing the row identifier used in the matrix lookup.
      • column_key: Field representing the column identifier used in the matrix lookup.
      • master_name: Name of the master file being referenced for the lookup.
      • default_value: Fallback value to use if no match is found in the matrix.