Skip to main content

FileType

1. Description​

The FileType Derivation Type is used to verify whether the input file extension is correct, file exists and can be open.

2. Screen Configuration​

file_type_image

CustId and AccNum values will be concatinated using '_' in AccNum output Field. 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 derivation type used is "FileType".
    • req_fields
      • extn: TXT/CSV/XLS/XLSX.
      • sheet_name: To be provided only when extn is XLS/XLSX.