Simple File Reader

Options

Settings

Input location

Enter a valid file name or URL. You can also choose a previously read file from the drop-down list, or select a file from the "Browse..." dialog.

Connection timeout [s]

Timeout in seconds for connections when reading remote files.

Autodetect format

By pressing this button, the "Column delimiter", "Row delimiter", "Quote char" and "Quote escape char" get automatically detected, though it is not guaranteed that the correct values are being detected.
Only a single file is considered for auto-detection, i.e., if "Files in folder" is selected only the first file is being used. The auto-detection by default is based on the first 1024 * 1024 characters of the selected file, but can be adjusted by clicking the settings button next to this option. The format can only be detected if the read number of characters comprises one full data row and the auto-detection will take at most 20 data rows into account. It is assumed that data rows are separated by line breaks. Note that the "Skip first lines" option as well as the specified "Comment char" will be used when guessing the file's format.

Column delimiter

The character string delimiting columns. Use '\t' for tab character. Can be detected automatically.

Row delimiter

The character string delimiting rows. Can get detected automatically.

• Line break: Uses the line break character as row delimiter. This option is platform-agnostic.
• Custom: Uses the provided string as row delimiter.

Quote char

The quote character. Can be detected automatically.

Quote escape char

The character is used for escaping quotes inside an already quoted value. Can be detected automatically.

Comment char

A character indicating line comments.

Has column header

Select this box if the first row contains column name headers.

Has row ID

Select this box if the first column contains row IDs (no duplicates allowed).

Support short data rows

Select this box if some rows may be shorter than others (filled with missing values).

Transformation

Transformations

This tab displays every column as a row in a table that allows modifying the structure of the output table. It supports reordering, filtering and renaming columns. It is also possible to change the type of the columns. Reordering is done via drag-and-drop. Just drag a column to the position it should have in the output table. Whether and where to add unknown columns during execution is specified via the special row <any unknown new column>. Note that the positions of columns are reset in the dialog if a new file or folder is selected.

Reset order

Resets the order of columns to the order in the input file/folder.

Reset filter

Clicking this button will reset the filters i.e. all columns will be included.

Reset names

Resets the names to the names that are read from file or created if the file/folder doesn't contain column names.

Reset types

Resets the output types to the default types guessed from the input file/folder.

Reset all

Resets all transformations.

Enforce types

Controls how columns whose type changes are dealt with. If selected, we attempt to map to the KNIME type you configured and fail if that's not possible. If unselected, the KNIME type corresponding to the new type is used.

Advanced Settings

Limit memory per column

If selected the memory per column is restricted to 1MB in order to prevent memory exhaustion. Uncheck this option to disable these memory restrictions.

Maximum number of columns

Sets the number of allowed columns (default 8192 columns) to prevent memory exhaustion. The node will fail if the number of columns exceeds the set limit.

Quote options

• Remove quotes and trim whitespaces: Quotes will be removed from the value followed by trimming any leading/trailing whitespaces.
• Keep quotes: The quotes of a value will be kept. Note: No trimming will be done inside the quotes.

Replace empty quoted strings with missing values

Select this box if you want quoted empty strings to be replaced by missing value cell.

Table specification

If enabled, only the specified number of input rows are used to analyze the file (i.e to determine the column types). This option is recommended for long files where the first n rows are representative for the whole file. The "Skip first data rows" option has no effect on the scanning. Note also, that this option and the "Limit data rows" option are independent from each other, i.e., if the value in "Limit data rows" is smaller than the value specified here, we will still read as many rows as specified here.

Support changing file schemas

If selected, the reader will compute the table specification on execution. This behavior is required if the content of the configured file/folder changes between executions, i.e., columns are added/removed to/from file(s) or their types change. NOTE: When checked, the node will not output a table specification during configure and won't apply transformations (therefore the transformation tab is disabled).

Number format

Allows to specify the thousands and decimal separator character for parsing numbers. The thousands separator is used for integer, long and double parsing, while the decimal separator is only used for the parsing of double values. Note that the two must differ. While it is possible to leave the thousands separator unspecified, you must always provide a decimal separator.

Limit Rows

Skip first lines

If enabled, the specified number of lines are skipped in the input file before the parsing starts. Use this option to skip lines that do not fit in the table structure (e.g. mult-line comments)

Skip first data rows

If enabled, the specified number of valid data rows are skipped. This has no effect on which row will be chosen as column header.

Limit data rows

If enabled, only the specified number of data rows are read. The column header row (if selected) is not taken into account.

Simple File Reader Encoding

Encoding

To read a 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"

Views

This node has no views

Workflows

• 01_Data_Importing_and_PreprocessingKNIME Hub
• 01_Data_Importing_and_Preprocessing_solutionKNIME Hub
• 014_External_WF_Call - 1KNIME Hub
• 05_Deploy_Trained_DL_ModelKNIME Hub
• 05_Deploy_Trained_DL_Model_solutionKNIME Hub
• Show all 30 workflows

Links

• Read and process HUGE csv Fileby izaychik63 on 2021-03-24

  forum.knime.com/p/119319
• NodePit, your search engine for KNIME nodes and workflowsby danielesser on 2020-07-20

  forum.knime.com/p/97425
• Simple File Readerby danielesser on 2020-07-17

  forum.knime.com/p/97216

Developers