User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Read Flat File Task

The Read Flat File task allows you to specify file and variable parameters for translating a flat file 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
Start Row	Specify the row to start reading data from the file(s). This setting allows any header rows to be skipped. The first row starts at 1.
Skip Empty Rows	Specify whether or not to skip empty rows. Rows with only spaces will also be skipped. Default Value: false
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 file encoding. This is required if the files are using a different encoding than the platform's default. Default Value: The platform's default file encoding.
Data Format Tab
Trim	Specify how the leading and trailing white spaces in the rows should be trimmed. By default no data is trimmed, i.e., all leading and trailing white spaces are preserved. Default Value: none
Null Indicator	Specify the value that should be interpreted as null when reading the data from the input files. If the data in any row matches the value specified here, it will be interpreted as a null.
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

This task uses the File Set Elements. The field definitions for the File Set Elements can be found on the File Lists and File Sets topic.

Rename Saved Search

Table of Contents

User Guide

User Guide

Read Flat File Task

Read Flat File Task