This node reads local and remote files. It can be configured to read the most common formats. If the file has a more complex structure, use the File Reader node which has more configuration options.
When you open the node's configuration dialog and provide a filename, it tries to guess the column specs by analyzing the content of the file. By default, only the first 50 rows are analyzed. You can change this setting in the 'Limit Rows' tab. The file analysis can also be cut short by clicking the "Stop file scanning" button, which shows up if the analysis takes longer. If the file is not analyzed completely, it could happen that the preview looks fine, but the execution of the node fails when it reads the lines it didn't analyze. Check the results of the analyzed file in the preview table and increase the number of rows scanned for guessing the spec if necessary.
Drag & drop to use
Drag & drop this node right into the Workflow Editor of KNIME Analytics Platform (4.x or higher).Learn more