DumbFileReader

Scans a folder for files, opens a file and creates a table based on the header line, then reads in the data of all other files into this table as strings. The intended application of the node is to read in data from analytic instruments. These data files are usually presented in tabular format in text files, but may contain unexpected entries in data sets (e.g. non-numeric entries like "overflow"). This node intends to overcome this problem by first reading in all data as strings, then the data can be converted within the KNIME workflow. If errors occur (too short or to long lines), these will be noted within the data table and execution of the node will continue. 3 columns will be added to the data: DumbFileReader.filename: the filename of the analyzed file. DumbFileReader.LineNumber: the line number within the file where the data set was extracted from. DumbFileReader.Error: fine if no error occurred, or type of error detected

Options

Folder
The directory that will be scanned for files
Line number of header line
column names will be derived from the content of the header line, line numbering starts with 1
Line number of first data line
Position of the first data line
Line number of last line
Position of the last data line
Delimiter
The column delimiter used in the files, default is tab \t

Input Ports

This node has no input ports

Output Ports

Icon
data table with all data as strings

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.