This step reads from a Java properties files. For more information on this file format, read this : http://en.wikipedia.org/wiki/.properties
The files tab is where you define the location of the files from which you want to read.
The table below contains options associated with the Files tab:
Option |
Description |
---|---|
Step Name |
Name of the step; the name has to be unique in a single transformation. |
Filenames from field |
|
File or directory |
Specifies the location and/or name of the input text file. |
Regular expression |
Specifies the regular expression you want to use to select the files in the directory specified in the previous option. |
Selected Files |
Contains a list of selected files (or wildcard selections) and a property specifying if file is required or not. If a file is required and it is not found, an error is generated;otherwise, the file name is skipped. |
Show filenames(s)... |
Displays a list of all files that will be loaded based on the current selected file definitions |
Option |
Description |
---|---|
Include filename in output? |
Allows you to specify a field name to include the file name (String) in the output of this step. |
Rownum in output |
Allows you to specify a field name to include the row number (Integer) in the output of this step. |
Reset rownum per file? |
Enable this option if you want the generated row number (optional) to be reset (to 1) at the start of every individual file. |
Limit |
Limits the number of rows to this number (zero (0) means all rows). |
Result filenames |
|
Option |
Description |
---|---|
Name |
The name of the output field |
Column |
The attribute to read |
Type |
The data type to convert to |
Format |
The format or conversion mask to use in the data type conversion |
Length |
The length of the output data type |
Precision |
The precision of the output data type |
Currency |
The currency symbol to use during data type conversion |
Decimal |
The numeric decimal symbol to use during data type conversion |
Group |
The numeric grouping symbol to use during data type conversion |
Trim type |
The type of trimming to use during data type conversion |
Repeat |
Repeat the column value of the previous row if the column value is empty (null) |