File Reader (Complex Format)

This node can be used to read data from a file. It can be configured to read various formats.
When you open the node's configuration dialog and provide a filename, it tries to guess the reader's settings by analyzing the content of the file. Check the results of these settings in the preview table. If the data shown is not correct or an error is reported, you can adjust the settings manually (see below).

The file analysis runs in the background and can be cut short by clicking the "Quick scan", which shows if the analysis takes longer. In this case the file is not analyzed completely, but only the first fifty lines are taken into account. It could happen then, that the preview appears looking fine, but the execution of the File Reader (Complex Format) fails, when it reads the lines it didn't analyze. Thus it is recommended you check the settings, when you cut an analysis short.
Note: In case this node is used in a loop, make sure that all files have the same format (e. g. separators, column headers, column types). The node saves the configuration only during the first execution.
Alternatively, the File Reader node can be used.

This node can access a variety of different file systems. More information about file handling in KNIME can be found in the official File Handling Guide.

Output ports

1. Type: Table
   File Table
   Datatable just read from the file

File System Connection (Dynamic Inport)

The file system connection.

1. Type: File System

External resources

• KNIME E-Learning Course: File Reader Node