CSV File Input
Description:
CSV file input is a step in the Input Plugin for Process Studio Workflows. CSV file input step is used to read data from a delimited file. You can define any separator you want to use, such as pipes, tabs, and semicolons in addition to commas. Internal processing without rendering the file leads to quick step execution. Options for this step are a subset of the Text File Input step.
Configurations:
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step. This name has to be unique in a single workflow. |
| 2 | Accept filenames from previous step | Select the checkbox if you want to use files from the previous the step. |
| 3 | Filename OR The filename field (data from previous steps) | Specify the name of the CSV file to read Note: The field is unavailable if you selected Accept filenames from previous step. OR, Select the fieldname that will contain the filename(s) to read from. If this step receives data from a previous step. Note: The field is available only if you select, Accept filenames from previous step checkbox. |
| 3.a | Include the filename in the output? | Select the checkbox if you want the name of the file to be included in the output. Note: The field is available only if you select, Accept filenames from previous step checkbox. |
| 4 | Delimiter | Specify the file delimiter character used in the target file. Special characters (e.g. CHAR HEX01) can be set with the format $[value], e.g. $[01] or $[6F,FF,00,1F]. |
| 5 | Enclosure | Specify the enclosure character used in the target file. Special characters (e.g. CHAR HEX01) can be set with the format $[value], e.g. $[01] or $[6F,FF,00,1F]. |
| 6 | NIO buffer size | Specify the size of the read buffer in bytes, read from the disk each time. |
| 7 | Lazy conversion | Enable this checkbox to enable lazy conversion algorithm. The lazy conversion algorithm tries to avoid unnecessary data type conversions that could lead to significant performance improvements if possible. |
| 8 | Header row present? | Enable this option if the target file should contain a header row containing column names. |
| 9 | Add filename to result | Enabling this checkbox adds the CSV filename(s) read to the result of the workflow. Filenames in result is a unique list being kept in memory that can be used in the next steps or parent workflow steps or parent process entries. |
| 10 | The row number field name (optional) | Specify the name of the Integer field that will contain the row number in the output of this step. |
| 11 | New line possible in fields? | Enable this checkbox if data in fields may contain new line characters. |
| 12 | Running in parallel? | Enable this checkbox if you will have multiple instances of this step running (step copies) and if you want each instance to read a separate part of the CSV file(s). |
| 13 | File Encoding | Specify the encoding of the file being read. |
| 14 | Fields Table | This table contains an ordered list of fields to be read from the file. |
| 15 | Preview button | Click to preview the data coming from the file. |
| 16 | Get Fields button | Click to get all the fields from the file based on the current settings (i.e. Delimiter, Enclosure, etc.). All fields identified will be added to the Fields Table. |