This file handling node has been replaced by the File Reader node. For further information about the new file handling framework see the File Handling Guide.
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.
Options
Settings
Transformation
Advanced Settings
Limit Rows
Simple File Reader Encoding
Popular Successors
- Column Filter8 %
- String Manipulation5 %
- Nominal Value Row Splitter5 %
- Constant Value Column4 %
- GroupBy3 %
- Concatenate3 %
- Read Images2 %
- Table Difference Checker2 %
Loop End2 %- Excel Writer2 %
- Cell Splitter2 %
- Cross Joiner2 %
- Reference Column Splitter2 %
- Joiner2 %
- CSV Writer2 %
- Stacked Area Chart (Plotly)2 %
Row Splitter (deprecated)2 %- Rule-based Row Splitter2 %
- String to Date&Time2 %
Joiner1 %Column Rename1 %- Rule-based Row Filter1 %
- Rule Engine1 %
Table Writer1 %- Table Creator1 %
- Number to String1 %
- String to Number1 %
- Column Rename (Regex)1 %
- Nominal Value Row Filter1 %
Row Filter (deprecated)1 %- Sorter1 %
- DB Writer1 %
Excel Writer (XLS)1 %- Benchmark Start (Memory Monitoring)< 1 %
Generic Loop Start< 1 %- Reference Column Filter< 1 %
- Column Expressions (legacy)< 1 %
- Strings to Document< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- String to URI< 1 %
CSV Writer< 1 %- Column Name Extractor< 1 %
- Row Filter (Labs)< 1 %
- Column Splitter< 1 %
- Table Difference Finder< 1 %
- Binary Objects to Strings< 1 %
- Upload (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table Column< 1 %Variable to Table Column< 1 %- Table Row to Variable< 1 %
Table Row To Variable Loop Start< 1 %- Column Auto Type Cast< 1 %
- Column Appender< 1 %
- Table Validator (Reference)< 1 %
- Double to Integer< 1 %
- Reference Row Filter< 1 %
- Pivot< 1 %
- String Manipulation (Multi Column)< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
- Extract Table Spec< 1 %
- DB Connector< 1 %
- DB Insert< 1 %
- Math Formula< 1 %
- Molecule to CDK< 1 %
- Text Extractor< 1 %
Binary Objects to Files< 1 %- Copy/Move Files (legacy)< 1 %
- Delete Files (legacy)< 1 %
- Extract URI Info< 1 %
- Variable to Table Column< 1 %
- Inject Variables (Data)< 1 %
- Java Snippet< 1 %
- Loop End (Column Append)< 1 %
- Chunk Loop Start< 1 %
Table Row To Variable Loop Start< 1 %- Table Row to Variable Loop Start< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
- k-Means< 1 %
- MultiLayerPerceptron Predictor< 1 %
- PCA< 1 %
- Add Empty Rows< 1 %
Cell Replacer< 1 %- Cell Splitter By Position< 1 %
- Column Renamer (Dictionary)< 1 %
- Column to Grid< 1 %
- Duplicate Row Filter< 1 %
- Extract Missing Value Cause< 1 %
- Missing Value Column Filter< 1 %
- Table Manipulator< 1 %
- Normalizer< 1 %
- Partitioning< 1 %
- Missing Value< 1 %
- Normalizer (PMML)< 1 %
- String Replacer< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Statistics< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
- Timer Info< 1 %
- Color Manager< 1 %
Parquet Writer< 1 %- Molecule Type Cast< 1 %
DB Table Creator< 1 %- OpenBabel< 1 %
Send to Power BI< 1 %- Java Snippet (simple)< 1 %
- Java Edit Variable (simple)< 1 %
- Keygraph Keyword Extractor< 1 %
- RegEx Filter< 1 %
- Stop Word Filter< 1 %
- RSS Feed Reader< 1 %
- Files/Folders Meta Info< 1 %
- Table View (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- String to JSON< 1 %
Python Script (1⇒1)< 1 %- Python Script (legacy)< 1 %
- R Snippet< 1 %
- GET Request< 1 %
Extract Date&Time Fields< 1 %- XPath< 1 %
- RDKit From Molecule< 1 %
- Google Address Geocoder< 1 %
- HTML Parser< 1 %
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-24forum.knime.com/p/119319
- NodePit, your search engine for KNIME nodes and workflowsby danielesser on 2020-07-20forum.knime.com/p/97425
- Simple File Readerby danielesser on 2020-07-17forum.knime.com/p/97216
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.