0 ×

CSV Reader

KNIME Base Nodes version 4.0.0.v201906241150 by KNIME AG, Zurich, Switzerland

Reads CSV files. Use this node if the workflow is used in a server or batch environment and the input files structure change between different invocations. In particular, this includes a variable number of input columns. Upon executing the node will scan the input file to determine number and types of the columns and output a table with the auto-guessed structure.

Note: If you are only using the desktop version of KNIME and your workflow is not meant to be used in a batch or server environment use the File Reader node. The file reader node has more configuration options and guesses meaningful default settings as it scans the input file during node configuration (in the dialog).

Options

CSV Reader

Custom connection timeout
Optional timeout in seconds for connections when reading remote files. When no value is provided, an application-wide default timeout will be used (usually 1s).
Column Delimiter
The character string delimiting columns. Use '\t' for tab character.
Row Delimiter
The character string delimiting rows. Use '\n' for new line character.
Quote Char
The quote character.
Comment Char
A character indicating line comments.
Has Column Header
Select this box if the first row contains column name headers.
Has Row Header
Select this box if the first column contains row name headers (no duplicates allowed).
Support Short Lines
Select this box if some rows may be shorter than others (filled with missings).

CSV Reader Encoding

Encoding
To read a csv file that contains characters in a different encoding, you can select the character set in this tab (UTF-8, UTF-16, etc.), or specify any other encoding supported by your Java VM. The default value uses the default encoding of the Java VM, which may depend on the locale or the Java property "file.encoding"

Limit Rows

Skip first lines
If enabled, the specified number of lines are skipped in the input file before the parsing starts.
Limit rows
If enabled, only the specified number of data rows are read. The column header row (if selected) is not taken into account.
Scan limit
If enabled, only the specified number of input lines are used to analyze the file (i.e to determine the column types). This option is recommended for long files where the first n lines are representative for the whole file.

Output Ports

File being read with number and types of columns guessed automatically.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows