Description
This step provides the ability to read data from a delimited file.
Options
The table below describes the options available for the CSV Input step:
Option |
Description |
|---|---|
Step name |
Name of the step.
|
Filename |
Specify the name of the CSV file to read from. |
Delimiter |
Specify the file delimiter character used in the target file. |
Enclosure |
Specify the enclosure character used in the target file. |
NIO buffer size |
Todo - description |
Lazy conversion |
Lazy conversion will avoid unnecessary data type conversions and can result in a significant performance improvements. Check to enable. |
Header row present? |
Enable this option if the target file contains a header row containing column names. |
Fields Table |
This table contains an ordered list of fields to be read from the target file. |
Preview button |
Click to preview the data coming from the target file. |
Get Fields button |
Click to return a list of fields from the target file based on the current settings (i.e. Delimiter, Enclosure, etc.). All fields identified will be added to the Fields Table. |