File Reader (Complex Format)

Options

Read from

Select a file system which stores the model you want to read. There are four default file system options to choose from:

• Local File System: Allows you to select a file from your local system.
• Mountpoint: Allows you to read from a mountpoint. When selected, a new drop-down menu appears to choose the mountpoint. Unconnected mountpoints are greyed out but can still be selected (note that browsing is disabled in this case). Go to the KNIME Explorer and connect to the mountpoint to enable browsing. A mountpoint is displayed in red if it was previously selected but is no longer available. You won't be able to save the dialog as long as you don't select a valid i.e. known mountpoint.
• Relative to: Allows you to choose whether to resolve the path relative to the current mountpoint, current workflow or the current workflow's data area. When selected, a new drop-down menu appears to choose which of the two options to use.
• Custom/KNIME URL: Allows to specify a URL (e.g. file://, http:// or knime:// protocol). When selected, a spinner appears that allows you to specify the desired connection and read timeout in milliseconds. In case it takes longer to connect to the host / read the file, the node fails to execute. Browsing is disabled for this option.

It is possible to use other file systems with this node. Therefore, you have to enable the file system connection input port of this node by clicking the ... in the bottom left corner of the node's icon and choose Add File System Connection port .
Afterwards, you can simply connect the desired connector node to this node. The file system connection will then be shown in the drop-down menu. It is greyed out if the file system is not connected in which case you have to (re)execute the connector node first. Note: The default file systems listed above can't be selected if a file system is provided via the input port.

File/URL

Enter a URL when reading from Custom/KNIME URL, otherwise enter a path to a file. The required syntax of a path depends on the chosen file system, such as "C:\path\to\file" (Local File System on Windows) or "/path/to/file" (Local File System on Linux/MacOS and Mountpoint). For file systems connected via input port, the node description of the respective connector node describes the required path format. You can also choose a previously selected file from the drop-down list, or select a location from the "Browse..." dialog. Note that browsing is disabled in some cases:

• Custom/KNIME URL: Browsing is always disabled.
• Mountpoint: Browsing is disabled if the selected mountpoint isn't connected. Go to the KNIME Explorer and connect to the mountpoint to enable browsing.
• File systems provided via input port: Browsing is disabled if the connector node hasn't been executed since the workflow has been opened. (Re)execute the connector node to enable browsing.

The location can be exposed as or automatically set via a path flow variable.

Preserve user settings

If checked, the checkmarks and column names/types you explicitly entered are preserved even if you select a new file. By default, the analyzer starts with fresh default settings for each new file location.

Rescan

If clicked, the file content is analyzed again. All settings are reset (unless the "Preserve user settings" option is selected) and the file is read in again to pre-set new settings and the table structure.

Read RowIDs

If checked, the first column in the file is used as RowIDs. If not checked, default row headers are created.

Read column headers

If checked, the items in the first line of the file are used as column names. Otherwise default column names are created.

Column delimiter

Enter the character(s) that separate the data tokens in the file, or select a delimiter from the list.

Ignore spaces and tabs

If checked, spaces and the TAB characters are ignored (not in quoted strings though).

Java style comment

Everything between '/*' and '*/' is ignored. Also everything after '//' until the end of the line.

Single line comment

Enter one or more characters that will indicate the start of a comment (ended by a new line).

Advanced...

Opens a new dialog with advanced settings. There is support for quotes, different decimal separators in floating point numbers, and character encoding. Also, for ignoring whitespaces, for allowing rows with too few data items, for making RowIDs unique (not recommended for huge files), for a global missing value pattern, and for limiting the number of rows read in.

Click on the table header

If the column header in the preview table is clicked, a new dialog opens where column properties can be set: name and type can be changed (and will be fixed then). A pattern can be entered that will cause a "missing cell" to be created when it's read for this column. Additionally, possible values of the column domain can be updated by selecting "Domain". And, you can choose to skip this column entirely, i.e. it will not be included in the output table then.

Views

This node has no views

Workflows

• 01_Chemistry_basicsKNIME Hub
• 01_Chemistry_basicsKNIME Hub
• 01_Clickstream_AnalysisKNIME Hub
• 01_ClusteringKNIME Hub
• 01_ClusteringKNIME Hub
• Show all 97 workflows

Links

• KNIME E-Learning Course: File Reader Node

  www.knime.com/knime-introductory-course/chapter2/section1/file-reader-node
• i am new in knime need to know which node will help to load data for attached file in knimeby izaychik63 on 2023-10-06

  forum.knime.com/p/237093

Developers