Caches all input data (rows) onto disk. This is particularly
useful when connected to a preceding node,
which performs a column transformation.
For example, a filter column node, which "hides" most
of the columns to the output. This node only caches the
data that is actually contained in the input table. Iterating on it
may be considerably faster than accessing the table of a wrapper node.
Note: This node does not have a dialog.
Popular Successors
- Joiner3 %
- Group Loop Start2 %
- GroupBy2 %
Excel Writer (XLS)2 %DB Loader1 %- Math Formula1 %
Variable to Table Column1 %- Column Filter1 %
- CSV Writer1 %
Column Appender1 %- Cache1 %
- Rule-based Row Filter1 %
- Similarity Search1 %
Row Splitter (deprecated)< 1 %- Partitioning< 1 %
- End IF< 1 %
Table Row to Variable< 1 %- IF Switch< 1 %
- Table Row to Variable Loop Start< 1 %
- Rule Engine< 1 %
Database Looping< 1 %- Column Aggregator< 1 %
- Workflow Reader< 1 %
- Java Snippet< 1 %
- Reference Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %- Excel Writer< 1 %
Table Writer< 1 %Recursive Loop Start< 1 %- Container Output (Table)< 1 %
- Constant Value Column< 1 %
Linear Correlation< 1 %Double To Int< 1 %Row Filter (deprecated)< 1 %- Extract Table Dimension< 1 %
- Scatter Plot (legacy)< 1 %
- Item Set Finder (Borgelt)< 1 %
File Reader< 1 %- Statistics< 1 %
- Java Snippet Row Splitter< 1 %
- Table View (JavaScript)< 1 %
- Variable Loop End< 1 %
- Column Rename (Regex)< 1 %
- Normalizer< 1 %
Column Rename< 1 %- SDF Writer< 1 %
- Microsoft SQL Server Connector< 1 %
- Scatter Plot (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- String to Date&Time< 1 %
- RDKit One Component Reaction< 1 %
- Benchmark Start< 1 %
- Wait...< 1 %
- Active Branch Inverter< 1 %
- Table Row to Variable< 1 %
Parameterized Database Query< 1 %List Files< 1 %- Loop End< 1 %
- Column List Loop Start< 1 %
- X-Partitioner< 1 %
- Decision Tree Learner< 1 %
Cell Replacer< 1 %- Number to Category (Apply)< 1 %
- Column Appender< 1 %
- Cross Joiner< 1 %
- CAIM Binner< 1 %
- Domain Calculator< 1 %
- Double to Integer< 1 %
- Normalizer (Apply)< 1 %
- Sorter< 1 %
- Column Splitter< 1 %
- Column Expressions< 1 %
- Math Formula (Variable)< 1 %
- Create File/Folder Variables< 1 %
- String to Date/Time (legacy)< 1 %
- Run Garbage Collector< 1 %
- Split Collection Column< 1 %
- File Meta Info (legacy)< 1 %
- Variable to Table Row< 1 %
- Table Writer< 1 %
- Table Creator< 1 %
- Loop End (Column Append)< 1 %
Loop End< 1 %Counting Loop Start< 1 %- Chunk Loop Start< 1 %
- Concatenate< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
String To Number< 1 %- Column Renamer< 1 %
- Lag Column< 1 %
- Column Resorter< 1 %
- CAIM Applier< 1 %
- Duplicate Row Filter< 1 %
- Nominal Value Row Filter< 1 %
Joiner< 1 %- Pivot< 1 %
- Missing Value< 1 %
- Normalizer (PMML)< 1 %
- Set Operator< 1 %
- String Manipulation< 1 %
- String Manipulation (Variable)< 1 %
- Table Difference Finder< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Rule-based Row Splitter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- CASE Switch End< 1 %
Color Appender< 1 %- Save Workflow< 1 %
Parquet Writer< 1 %- Parquet Writer< 1 %
- Workflow Executor< 1 %
- Parallel Chunk End< 1 %
- Vertica Connector< 1 %
- DB Insert< 1 %
- DB Merge< 1 %
- DB Writer< 1 %
- DB Table Creator< 1 %
- Counter Generation< 1 %
- External Tool< 1 %
- Math Formula (Multi Column)< 1 %
XLS Writer< 1 %- Java Snippet (simple)< 1 %
- Local File Browser Configuration< 1 %
- JSON Path< 1 %
- Container Output (JSON)< 1 %
- Python Script (legacy)< 1 %
Call Workflow Service< 1 %- RDKit Substructure Filter< 1 %
- RDKit Two Component Reaction< 1 %
Table Reader< 1 %Recursive Loop End< 1 %Naive Bayes Predictor< 1 %- Auto-Binner< 1 %
Cell Splitter< 1 %- Column Combiner< 1 %
- String to Number< 1 %
- Denormalizer< 1 %
- Column Filter (PMML)< 1 %
- Rank< 1 %
CASE Switch Variable (Start)< 1 %- Color Manager< 1 %
Parquet Writer< 1 %- Molecule Type Cast< 1 %
- Explorer Browser< 1 %
- SSH Connector< 1 %
- JSON to Table< 1 %
- RDKit Canon SMILES< 1 %
- Speedy SMILES Strip Double Bond Geometry< 1 %
- Fix Column Names< 1 %
Variable to Table Row< 1 %- Table to Image< 1 %
CSV Writer< 1 %Database SQL Executor< 1 %Loop End (2 ports)< 1 %- Hierarchical Clustering< 1 %
- Hierarchical Cluster View< 1 %
- MultiLayerPerceptron Predictor< 1 %
Concatenate (Optional in)< 1 %- Category to Number< 1 %
- Column Name Extractor< 1 %
- Missing Value Column Filter< 1 %
- RowID< 1 %
String Replace (Dictionary)< 1 %CASE Switch Data (Start)< 1 %- Empty Table Creator< 1 %
- Random Number Assigner< 1 %
- k-Medoids< 1 %
Excel Sheet Appender (XLS)< 1 %- t-SNE (L. Jonsson)< 1 %
- Line Plot (JavaScript)< 1 %
Column Selection QuickForm (legacy)< 1 %- Add Table to R< 1 %
- Date&Time Difference< 1 %
- Date&Time-based Row Filter< 1 %
- XML Writer< 1 %
- RDKit From Molecule< 1 %
- PDB Loader< 1 %
- Chemical Search< 1 %
- Read Images< 1 %
Database Writer< 1 %- Table Reader< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Interval Loop Start< 1 %- Decision Tree Predictor< 1 %
Scorer< 1 %- Association Rule Learner< 1 %
Random Forest Learner (Regression)< 1 %- Random Forest Predictor< 1 %
- Auto-Binner (Apply)< 1 %
- Column Renamer (Dictionary)< 1 %
- Column to Grid< 1 %
- Correlation Filter< 1 %
- Reference Column Filter< 1 %
- Interactive HiLite Collector< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Splitter< 1 %
Normalizer< 1 %- Reference Column Resorter< 1 %
- Number Rounder< 1 %
- Numeric Row Splitter< 1 %
- String Replacer< 1 %
- Value Counter< 1 %
- Ruleset Predictor< 1 %
- Extract Table Spec< 1 %
- Global Timer Info< 1 %
- Conditional Box Plot (legacy)< 1 %
- Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Parallel Chunk Start< 1 %
- DB Delete (Table)< 1 %
- String Distances< 1 %
- Distance Matrix Calculate< 1 %
- Send to Power BI< 1 %
Strings To Document< 1 %- Weka Predictor (3.7)< 1 %
- List Files/Folders< 1 %
- Column Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Column Selection Widget< 1 %
- Image Resizer< 1 %
- Feature Table< 1 %
- Parameter Optimization Loop Start< 1 %
Python Script (2⇒1)< 1 %- UNIX Timestamp to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Date Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Row Splitter (col+)< 1 %
- Hydrogen Adder< 1 %
- Reaction Splitter< 1 %
- Domain - Leverage< 1 %
Flow Variable End IF< 1 %- Multiport Loop End< 1 %
- Write Variables< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- Benchmark End< 1 %
- Save File Locally< 1 %
- PDB Downloader< 1 %
- Outlier Removal< 1 %
- Matlab Snippet< 1 %
Open in Python< 1 %- Structure Checker< 1 %
- Write To Excel Template (deprecated)< 1 %
- ARIMA Learner< 1 %
- Copy/Move Files (legacy)< 1 %
- Download / Upload from List (legacy)< 1 %
- Strings to Binary Objects< 1 %
- URL to File Path< 1 %
- Zip Files (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table column< 1 %Variable to Table Column< 1 %- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %CSV Reader< 1 %Database Delete< 1 %Database Reader< 1 %Database Update< 1 %Database Drop Table< 1 %Database Table Creator< 1 %- Java Edit Variable< 1 %
Variable Condition Loop End< 1 %Generic Loop Start< 1 %Recursive Loop Start (2 ports)< 1 %Variable Loop End< 1 %- X-Aggregator< 1 %
Naive Bayes Learner< 1 %- Naive Bayes Learner< 1 %
- Cluster Assigner< 1 %
- k-Means< 1 %
- RProp MLP Learner< 1 %
PCA Compute< 1 %PCA< 1 %- Logistic Regression Predictor< 1 %
- Regression Predictor< 1 %
- Numeric Scorer< 1 %
- SVM Learner< 1 %
- PCA Apply< 1 %
- PCA< 1 %
Gradient Boosted Trees Learner< 1 %- Gradient Boosted Trees Learner (Regression)< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Random Forest Learner< 1 %
- Random Forest Learner (Regression)< 1 %
Random Forest Predictor< 1 %- Add Empty Rows< 1 %
- Numeric Binner< 1 %
- Binner (Dictionary)< 1 %
- Create Bit Vector< 1 %
- Case Converter< 1 %
- Column Comparator< 1 %
Number To String< 1 %- Column Merger< 1 %
- Many to One< 1 %
- One to Many< 1 %
- Table Validator< 1 %
- Edit Nominal Domain< 1 %
- Filter Apply< 1 %
- Row Filter (Labs)< 1 %
- Table Manipulator< 1 %
- Number to String (PMML)< 1 %
String To Number (PMML)< 1 %- String Splitter (Regex)< 1 %
- Row Sampling< 1 %
- String Manipulation (Multi Column)< 1 %
- Top k Row Filter< 1 %
- Rule Engine Variable< 1 %
- Rule Engine (Dictionary)< 1 %
- Data Explorer< 1 %
Shapiro Wilk Normality Test< 1 %- Single sample t-test< 1 %
- Paired t-test< 1 %
- Independent groups t-test< 1 %
- CASE Switch Start< 1 %
CASE Switch Variable (End)< 1 %- Empty Table Switch< 1 %
CASE Switch Data (End)< 1 %Merge Variables< 1 %- Send Email< 1 %
- Timer Info< 1 %
- Crosstab< 1 %
- Interactive Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Size Manager< 1 %
- Interactive Table (legacy)< 1 %
Impala Loader (legacy)< 1 %- Mol2 Writer< 1 %
- Parallel Chunk End (multi port)< 1 %
- DB Query Reader< 1 %
DB Table Creator< 1 %- DB Table Selector< 1 %
- Gaussian Distributed Assigner< 1 %
- TimeDelay Loop Start< 1 %
- Java Distance< 1 %
- Numeric Distances< 1 %
K Nearest Neighbor (Distance Function)< 1 %- Box Plot (JavaScript)< 1 %
- Violin Plot (Plotly)< 1 %
PMML Predictor< 1 %- PMML Predictor< 1 %
- Cell to PMML< 1 %
Table to HTML< 1 %Table to PDF< 1 %- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- Table to H2O< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Table Indexer< 1 %
Excel Writer (XLS)< 1 %- Excel Reader< 1 %
- Java IF (Table)< 1 %
- Radar Plot Appender< 1 %
- Word2Vec Learner (legacy)< 1 %
- StanfordNLP Relation Extractor< 1 %
- Chi-Square Keyword Extractor< 1 %
- Keygraph Keyword Extractor< 1 %
- NGram Creator< 1 %
- String Matcher< 1 %
- Tika Language Detector< 1 %
- Number Filter< 1 %
Bag of Words Creator< 1 %- Bag Of Words Creator< 1 %
- Sentence Extractor< 1 %
- String to Term< 1 %
- Document Viewer< 1 %
- String to Path (Variable)< 1 %
- Transfer Files (Table)< 1 %
- Column Filter Configuration< 1 %
- Multiple Selection Configuration< 1 %
- Text Output (legacy)< 1 %
- Boolean Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Lift Chart (JavaScript)< 1 %
- Value Selection Widget< 1 %
- JSON Row Combiner and Writer< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
- Columns to JSON< 1 %
- Sigma Filter< 1 %
- Global Thresholder< 1 %
- Don't Save Start< 1 %
- Parameter Optimization Loop End< 1 %
- Score Erosion< 1 %
Python Script (2⇒1)< 1 %Multi Selection QuickForm (legacy)< 1 %- R Predictor< 1 %
- R Snippet< 1 %
- R View (Table)< 1 %
- Table to R< 1 %
- Data to Report (BIRT)< 1 %
- GET Request< 1 %
- Table Difference Checker< 1 %
- Logger Option< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Date&Time Part Extractor< 1 %
- Date&Time Shift< 1 %
- Time Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- Time to String (legacy)< 1 %
XML Writer< 1 %- XPath< 1 %
- Molecular Properties< 1 %
- Fingerprint Similarity< 1 %
- RDKit Add Hs< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Count-Based Fingerprint< 1 %
- RDKit Fingerprint< 1 %
- Text Classifier Learner< 1 %
- Geo Distances< 1 %
Regex Extractor< 1 %- HTTP Retriever< 1 %
Views
- This node has no views
Workflows
_01_TestWF_Fails_Then_SucceedsKNIME Hub- _02_TestWF_FailsKNIME Hub
- _03_TestWF_SucceedsKNIME Hub
- _Configuration_TemplateKNIME Hub
- 01_ChurnAnalysisKNIME Hub
- Show all 71 workflows
Links
- How to improve the performance of Joiner nodeby izaychik63 on 2019-08-08forum.knime.com/p/67463
- Ways to speed this up? 10M + rowsby izaychik63 on 2023-06-30forum.knime.com/p/227582
- Writing large csv files + memory issuesby izaychik63 on 2019-05-03forum.knime.com/p/59909
- Performance questionby izaychik63 on 2018-11-08forum.knime.com/p/49715
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.