Table of Contents

Search

  1. Preface
  2. Introduction
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Read Fixed-width Task

Read Fixed-width Task

The Read Fixed-width task allows you to specify file and variable parameters for translating a fixed-width file into a RowSet variable.
Field
Definition
Basic Tab
Label
Specify a label for this task.
Input File
Specify the path and file name of a single file to read the data from.
Input Files Variable
Specify the name of a variable of type File List which contains the files to read the data from. For example, ${variableName}.
Output RowSet Variable
Specify the name of a variable which will contain the data read from the specified input file(s). The variable will be of type RowSet and may be used in subsequent tasks that accept a RowSet input variable. The variable will be created if it does not exist.
Advanced Tab
Skip Invalid Records
Specify whether or not to ignore invalid records and continue on. The default is false, which will signal a error when invalid data is encountered.
Default Value: false
Skip First Row
Specify whether or not to skip the first row of the input file(s). If the input file(s) contain header information in the first row, set this value to 'true'.
Default Value: true
Record Delimiter
Specify the character or sequence of characters that are used to separate each record in the input file(s). The default record delimiter is CRLF (carriage return immediately followed by line feed).
Default Value: CRLF
Encoding
Specify the character encoding of the input file(s). The default value is same as the platform's default file encoding.
Default Value: The platform's default file encoding.
Output Variables Tab
Processed Input Files Variable
If desired, specify the name of a variable which will contain the processed input files. The variable will be of type File List and may be used in subsequent tasks that accept a File List input variable. The variable will be created if it does not exist.
Control Tab
Version
The version of this task.
Log Level
Specify the level of logging to use while executing this task. Valid options are - silent, normal, verbose and debug.
Default Value: Inherited from parent Module
Execute Only If
Specify a condition that must be satisfied before this task can be executed. This task will be skipped if the specified condition is not met.
Disabled
Whether or not this task is disabled.
Default Value: false
On Error Tab
On Error
Specify the action to take when this task errors out. Valid options are - abort, continue, call:[module] and setVariable:[name]=[value]. For call:[module] replace [module] with the name of the module in the project (e.g. call:ErrorModule). For setVariable:[name]=[value] replace [name] with a variable name and [value] with the variable value (e.g. setVariable:error=true).
Default Value: Inherited from parent Module

0 COMMENTS

We’d like to hear from you!