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.
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.
Options
Popular Successors
- Joiner7 %
Row Filter (deprecated)5 %- Column Filter4 %
- String Manipulation3 %
- Concatenate3 %
- Missing Value3 %
- GroupBy3 %
- Cell Splitter2 %
- Rule-based Row Filter2 %
- Partitioning2 %
- Excel Writer2 %
Column Rename1 %- CSV Writer1 %
- String to Date&Time1 %
Row Splitter (deprecated)1 %- Statistics View1 %
- Math Formula1 %
- Loop End1 %
- Constant Value Column1 %
- Rule Engine1 %
Database Writer< 1 %- Statistics< 1 %
- RDKit From Molecule< 1 %
- Cross Joiner< 1 %
Cell Replacer< 1 %- Normalizer< 1 %
- RowID< 1 %
- Logistic Regression Predictor< 1 %
- Column Appender< 1 %
- Unpivot< 1 %
- Extract Table Dimension< 1 %
- Auto-Binner< 1 %
- String to Number< 1 %
- Linear Correlation< 1 %
- Rule-based Row Splitter< 1 %
- Conditional Box Plot (legacy)< 1 %
- k-Means< 1 %
- Pie chart (legacy)< 1 %
- One Row to Many< 1 %
Regex Extractor< 1 %- Table Row to Variable Loop Start< 1 %
- Double to Integer< 1 %
- Duplicate Row Filter< 1 %
- Crosstab< 1 %
- Molecule Type Cast< 1 %
- Linear Regression Learner< 1 %
- Nominal Value Row Filter< 1 %
- Table Manipulator< 1 %
- Numeric Outliers< 1 %
- Color Manager< 1 %
- DB Writer< 1 %
- String to Date/Time (legacy)< 1 %
- XPath< 1 %
- RDKit Canon SMILES< 1 %
- Java Snippet< 1 %
- Polynomial Regression Learner< 1 %
- Numeric Binner< 1 %
- Empty Table Switch< 1 %
- Box Plot (legacy)< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- Dictionary Tagger< 1 %
- Transfer Files (Table)< 1 %
- Column Filter (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- R Snippet< 1 %
RDKit Functional Group Filter< 1 %Loop End< 1 %- Decision Tree Predictor< 1 %
- Regression Predictor< 1 %
- Create Bit Vector< 1 %
- Number to Category (Apply)< 1 %
- End IF< 1 %
- Scatter Matrix (legacy)< 1 %
- Table Difference Checker< 1 %
- Text Extractor< 1 %
- Variable to Table Column< 1 %
- Entropy Scorer< 1 %
- Category to Number< 1 %
- Column Rename (Regex)< 1 %
- Row Splitter (Labs)< 1 %
- Data Explorer< 1 %
- Interactive Table (legacy)< 1 %
- Parallel Chunk Start< 1 %
- XML Writer< 1 %
- XML Row Combiner< 1 %
- String to XML< 1 %
- RDKit To InChI< 1 %
- Combinatorial Reaction Enumeration (beta)< 1 %
- Advanced MolConverter< 1 %
- Create Collection Column< 1 %
- Table Row to Variable< 1 %
- SMOTE< 1 %
- Random Forest Predictor< 1 %
- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- Number to String< 1 %
- Column Renamer< 1 %
- One to Many< 1 %
- Reference Column Filter< 1 %
- Constant Value Column Filter< 1 %
- Row Filter (Labs)< 1 %
- Number Rounder< 1 %
- Sorter< 1 %
- Column Splitter< 1 %
- String Replacer< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Extract Table Spec< 1 %
- Interactive Histogram (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- SDF Writer< 1 %
- Column Expressions< 1 %
- OpenBabel< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- N Chars Filter< 1 %
- Document Data Extractor< 1 %
- Document Viewer< 1 %
- XML to JSON< 1 %
- JSON to Table< 1 %
- RDKit Fingerprint< 1 %
- RDKit Substructure Filter< 1 %
- RDKit Substructure Counter< 1 %
- HTML Parser< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- Load text-based files< 1 %
- MolSimilarity< 1 %
Binary Objects to Files< 1 %- Copy/Move Files (legacy)< 1 %
- URL to File Path< 1 %
- Read Images< 1 %
- ARFF Writer< 1 %
- File Reader (Complex Format)< 1 %
- Table Writer< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Variable Loop End< 1 %
- X-Partitioner< 1 %
- Decision Tree Learner< 1 %
- Logistic Regression Learner< 1 %
- SVM Learner< 1 %
- SVM Predictor< 1 %
- PCA Compute< 1 %
- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
- Category to Number (Apply)< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Resorter< 1 %
- Correlation Filter< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Pivot< 1 %
- Column Filter (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
- String Splitter (Regex)< 1 %
- Numeric Row Splitter< 1 %
- Row Sampling< 1 %
- Shuffle< 1 %
- String Manipulation (Multi Column)< 1 %
- Table Difference Finder< 1 %
- Table Transposer< 1 %
- Value Counter< 1 %
- Timer Info< 1 %
- Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Shape Manager< 1 %
- Table View< 1 %
- DB Table Creator< 1 %
- Counter Generation< 1 %
- Numeric Distances< 1 %
- Table to PDF (legacy)< 1 %
- Excel Cell Updater< 1 %
- Stop Word Filter< 1 %
- Sentence Extractor< 1 %
- Strings to Document< 1 %
- Path to String< 1 %
- Path to String (Variable)< 1 %
- String to Path< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- String to JSON< 1 %
- Python Script (legacy)< 1 %
- Date&Time Difference< 1 %
- Date&Time Part Extractor< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit To Molecule< 1 %
- Regex Extractor< 1 %
- HTML Node to Text< 1 %
- Extract URI Info< 1 %
- Group Loop Start< 1 %
- Hierarchical Clustering< 1 %
- Tree Ensemble Predictor< 1 %
- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
- Rank Correlation< 1 %
- Cache< 1 %
- OSM Map View< 1 %
- Punctuation Erasure< 1 %
- Column Selection Configuration< 1 %
- RDKit Generate Coords< 1 %
- RDKit Salt Stripper< 1 %
- Binary Objects to PNGs< 1 %
- Strings to Binary Objects< 1 %
- CSV Reader< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Column Merger< 1 %
- IF Switch< 1 %
- Math Formula (Multi Column)< 1 %
- Tika Parser URL Input< 1 %
- Fingerprints< 1 %
Table Column to Variable< 1 %- Gradient Boosted Trees Learner< 1 %
- Ungroup< 1 %
Color Appender< 1 %- TimeDelay Loop End< 1 %
- Distance Matrix Calculate< 1 %
- Tableau Writer< 1 %
- Diacritic Remover< 1 %
- String to Term< 1 %
- Lift Chart (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- JSON to XML< 1 %
- Webpage Retriever< 1 %
- RDKit Molecule Extractor< 1 %
- XLS Control Table Generator< 1 %
- Table Merger< 1 %
- Force Field Conformer Energies< 1 %
- PDB Property Extractor< 1 %
- Plate Row Converter< 1 %
- Open in Python< 1 %
- logD< 1 %
- MolConverter< 1 %
- Split Collection Column< 1 %
- Files to Binary Objects< 1 %
- Naive Bayes Predictor< 1 %
- Fuzzy Rule Predictor< 1 %
- Hierarchical Cluster View< 1 %
- MDS< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Scorer< 1 %
- PCA< 1 %
- Tree Ensemble Learner< 1 %
- Table Validator (Reference)< 1 %
- Domain Calculator< 1 %
- Nominal Value Row Splitter< 1 %
- Subset Matcher< 1 %
Normalizer< 1 %String Replace (Dictionary)< 1 %- Target Shuffling< 1 %
- Rule Engine (Dictionary)< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
- Linear Discriminant Analysis< 1 %
CASE Switch Data (Start)< 1 %- Size Manager< 1 %
Parquet Writer< 1 %- k-Medoids< 1 %
- Contour Plot (Plotly)< 1 %
- Line Plot (Plotly)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Index Query< 1 %
- Send to Power BI< 1 %
- Java Snippet (simple)< 1 %
- Java Edit Variable (simple)< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Chi-Square Keyword Extractor< 1 %
- Keygraph Keyword Extractor< 1 %
- Tika Language Detector< 1 %
- Dictionary Replacer< 1 %
- Replacer< 1 %
- POS Tagger< 1 %
- StanfordNLP NE Tagger< 1 %
- Tags to String< 1 %
- Files/Folders Meta Info< 1 %
- Column Selection (legacy)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Heatmap (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Column Selection Widget< 1 %
- Value Selection Widget< 1 %
- Table to JSON< 1 %
- JSON Path< 1 %
- JSON Schema Validator< 1 %
- Tess4J< 1 %
- Python Predictor (legacy)< 1 %
- Python View (legacy)< 1 %
- Date&Time to String< 1 %
- Date&Time to legacy Date&Time< 1 %
- Modify Date< 1 %
- Moving Average< 1 %
- Column to XML< 1 %
- Lipinski's Rule-of-Five< 1 %
- RDKit Molecule Catalog Filter< 1 %
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 84 workflows
Links
- KNIME E-Learning Course: File Reader Nodewww.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-06forum.knime.com/p/237093
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.