Skip to main content

FooterCount

1. Description​

The FooterCount Derivation Type is used to validate if Footer record count matches actual row count or not.

2. Screen Configuration​

footer_count_image

Based on the configured footer_count, the program skips the specified number of rows from the end of the file and uses the character positions defined in exclude_char to extract and validate the record count present in the footer. Let's assume CustId="C1" and AccNum="A01", then it will give "C1_A01" in the output.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type. Possible values are: "String".
  • dervation
    • derivation_type: The calculation type used is "FooterCount".
    • req_fields
      • footer_count: TextBox where you need to mention the footer count.
      • exclude_char: Comma separated values specifying the starting and ending character position to be read for calculation.