CSV Row Iterator
The CSV Row Iterator allows for parsing of Comma Separated Value (CSV) files. CSV files are text documents, resembling the format of a spreadsheet, where columns of data values are typically separated by a comma delimiter.
Input Parameters:
- CSV File: This is the CSV file to process. Typically this is the input from a previous File Iterator
- File Encoding: Typically UTF-8 but can be adjusted if your CSV file has an extended encoding
- Row Number Of Header: Which Row in the CSV file has the header names of the columns. Set this to 0 if there is not header row
- Skip Row Count: Number of rows (line breaks) to skip from the top of the CSV. Use this when there are blank lines or non-formatted data at the start of the CSV file
- Delimiter: The character that delimits where the data values/columns are separated
Output Entity:
The output entity is where the definition of the columns and thus values that will be parsed. In essence, this is where you describe the format (columns) of the CSV file.
Click on the pencil icon in the top right to edit the definition.
To add additional Attributes (CSV columns) to the definition, drag one of the Available Attributes from the left side into the Defined Attributes section in the middle area.
Attribute Definitions:
CSV Row Column (By Index)
- Name: The display name used when later mapping the value of the column in a future step
- Binding: The Index (integer) of the column number in the spreadsheet, starting with 0
- Data Stype: Defaults to string as the input is always a text file string value
- Convert Data Type: Use this checkbox to indicate the string should be converted when read and select the data type to convert to
CSV Row Column (By Name)
- Name: The display name used when later mapping the value of the column in a future step
- Binding: The name used in the CSV for the column to be referenced
- Data Stype: Defaults to string as the input is always a text file string value
- Convert Data Type: Use this checkbox to indicate the string should be converted when read and select the data type to convert to
NOTE: To use a path/filename in the CSV as a reference to the binary file to upload, use one of the CSV Row Column references as above, but use the 'Convert Data Type' option and set it to Binary. This will retrun a reference to the binary file from the csv for processing in a future method.