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 Predecessors
- Loop End2 %
String To Number2 %Row Filter (deprecated)2 %Excel Reader (XLS)2 %- Excel Writer2 %
- DB Query Reader1 %
Variable Loop End1 %- Column Filter1 %
- Cache1 %
- Read Images1 %
- Nominal Value Row Filter1 %
List Files1 %Concatenate (Optional in)1 %- Rule-based Row Filter1 %
Table Writer< 1 %Excel Reader (XLS)< 1 %Recursive Loop End< 1 %- GET Request< 1 %
File Reader< 1 %- k-Means< 1 %
- Concatenate< 1 %
- GroupBy< 1 %
- CSV Reader< 1 %
Number To String< 1 %- String Manipulation< 1 %
- Color Manager< 1 %
Extract Date&Time Fields< 1 %- Extract System Properties< 1 %
- Table Row to Variable< 1 %
- SDF Writer< 1 %
Loop End< 1 %Cell Splitter< 1 %- String Manipulation (Variable)< 1 %
- Create Table Structure< 1 %
- Ungroup< 1 %
- DB Reader< 1 %
- String to Date&Time< 1 %
- CASE Switch End< 1 %
- Unzip Files (legacy)< 1 %
- Chunk Loop Start< 1 %
Scorer< 1 %- Constant Value Column< 1 %
Joiner< 1 %- SDF Reader< 1 %
- Math Formula (Multi Column)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Table View (JavaScript)< 1 %
- List Files/Folders< 1 %
- CASE Switch Start< 1 %
- Active Branch Inverter< 1 %
- Auto-Binner< 1 %
- Reference Row Filter< 1 %
- Data Generator< 1 %
XLS Reader< 1 %- Java IF (Table)< 1 %
- Column Rename (Regex)< 1 %
- Table Validator (Reference)< 1 %
- Math Formula (Variable)< 1 %
- Variable to Table Row< 1 %
- Table Writer< 1 %
- Table Manipulator< 1 %
Database Reader< 1 %- Table Creator< 1 %
- Group Loop Start< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Resorter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Splitter< 1 %
- Partitioning< 1 %
- Rule-based Row Splitter< 1 %
- IF Switch< 1 %
- Math Formula< 1 %
- JSON to Table< 1 %
- String to XML< 1 %
- Try (Data Ports)< 1 %
- Duplicate Row Filter< 1 %
- Save Workflow< 1 %
- Column Expressions< 1 %
- Regression Predictor< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
Parquet Writer< 1 %- DB Insert< 1 %
- Parameterized DB Query Reader< 1 %
- Files/Folders Meta Info< 1 %
- Wait...< 1 %
CSV Reader< 1 %- Java Snippet< 1 %
- Normalizer< 1 %
- Missing Value< 1 %
Column Rename< 1 %- Number Rounder< 1 %
- RowID< 1 %
- Row Sampling< 1 %
- Set Operator< 1 %
- Sorter< 1 %
- Rule Engine< 1 %
- Rule Engine Variable< 1 %
- Statistics< 1 %
- Empty Table Switch< 1 %
- Item Set Finder (Borgelt)< 1 %
- Java Snippet (simple)< 1 %
- R Snippet< 1 %
- String to Date/Time (legacy)< 1 %
- Breakpoint< 1 %
- Fixed Width File Reader< 1 %
Cell Replacer< 1 %- Cell Splitter< 1 %
- Number to String< 1 %
- String to Number< 1 %
- R Source (Table)< 1 %
- RDKit Substructure Filter< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- File Reader< 1 %
- Table Reader< 1 %
- Joiner< 1 %
- Normalizer (Apply)< 1 %
- DB Connection Closer< 1 %
- Excel Reader< 1 %
- CSV Writer< 1 %
- Decision Tree to Ruleset< 1 %
- Domain Calculator< 1 %
- Extract URI Info< 1 %
Table Reader< 1 %- Cross Joiner< 1 %
- Equal Size Sampling< 1 %
- Parallel Chunk End< 1 %
- Time Difference (legacy)< 1 %
- Download (legacy)< 1 %
- List Remote Files (legacy)< 1 %
- ARFF Reader< 1 %
- Case Converter< 1 %
- String Replacer< 1 %
- Fingerprint Bayesian Predictor< 1 %
- DB Query Extractor< 1 %
- String to JSON< 1 %
- File Reader (Complex Format)< 1 %
- Correlation Filter< 1 %
- Modify Time< 1 %
Parameterized Database Query< 1 %- Decision Tree Predictor< 1 %
Random Forest Predictor< 1 %- Java Edit Variable (simple)< 1 %
- Value Filter (legacy)< 1 %
- Copy/Move Files (legacy)< 1 %
- Find MIME-Type< 1 %
- List MIME-Types< 1 %
- String to URI< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %- Java Edit Variable< 1 %
- Column Auto Type Cast< 1 %
- Parallel Chunk End (multi port)< 1 %
- Parallel Chunk Start< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Two Component Reaction< 1 %
- String Manipulation (Multi Column)< 1 %
- DB Loader< 1 %
- Counter Generation< 1 %
- Inject Variables (Data)< 1 %
Loop End (2 ports)< 1 %- Column List Loop Start< 1 %
Double To Int< 1 %- Missing Value Column Filter< 1 %
- Pivot< 1 %
- Table Transposer< 1 %
- Index Query< 1 %
Excel Reader (XLS)< 1 %- Keygraph Keyword Extractor< 1 %
- Dictionary Filter< 1 %
- Scatter Plot (JavaScript)< 1 %
- Python Source (legacy)< 1 %
- Run Heavy Garbage Collector< 1 %
- Create Collection Column< 1 %
- Download / Upload from List (legacy)< 1 %
Line Reader< 1 %Model Reader< 1 %- Loop End (Column Append)< 1 %
Recursive Loop End (2 ports)< 1 %PCA< 1 %- One to Many< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Edit Numeric Domain< 1 %
- Rank< 1 %
- String Splitter (Regex)< 1 %
- Numeric Outliers (Apply)< 1 %
- Extract Table Spec< 1 %
- ROC Curve (legacy)< 1 %
- External Tool< 1 %
- Container Input (Table)< 1 %
- Table to JSON< 1 %
- JSON Path< 1 %
Python Script (1⇒2)< 1 %- Date&Time to legacy Date&Time< 1 %
- Variable to Table Column< 1 %
- Line Reader< 1 %
- Reference Column Filter< 1 %
- Normalizer (PMML)< 1 %
- DB Delete (Table)< 1 %
- Container Input (Credentials)< 1 %
Flow Variable IF Switch< 1 %- Delete Files (legacy)< 1 %
Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %Database Connection Table Reader< 1 %Database Looping< 1 %Database Table Selector< 1 %- Linear Regression Learner< 1 %
Regression Predictor< 1 %- Column Combiner< 1 %
Column Appender< 1 %Linear Correlation< 1 %- Double to Integer< 1 %
- Column Splitter< 1 %
- End IF< 1 %
- Timer Info< 1 %
Stop Word Filter< 1 %- Tag Filter< 1 %
- Google Analytics Query (legacy)< 1 %
- Double Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Container Input (JSON)< 1 %
Python Script (1⇒1)< 1 %- POST Request< 1 %
- Date&Time-based Row Filter< 1 %
- Date Field Extractor (legacy)< 1 %
- Molecular Properties< 1 %
- Fingerprint Similarity< 1 %
- HTTP Retriever< 1 %
- Quit WebDriver< 1 %
- Reaction Splitter< 1 %
- Fingerprint From String< 1 %
IF Switch (Flow Variable Value)< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- Benchmark Start< 1 %
- Model Reader< 1 %
- ChemSpider< 1 %
- Binary Objects to PNGs< 1 %
- File Meta Info (legacy)< 1 %
- Files to Binary Objects< 1 %
- Strings to Binary Objects< 1 %
- URL to File Path< 1 %
- Image to Table< 1 %
Database SQL Executor< 1 %Database Update< 1 %SQL Extract< 1 %- Feature Selection Filter< 1 %
Counting Loop Start< 1 %Generic Loop Start< 1 %- X-Aggregator< 1 %
- MultiLayerPerceptron Predictor< 1 %
PCA Apply< 1 %- SMOTE< 1 %
- Association Rule Learner< 1 %
- Random Forest Predictor (Regression)< 1 %
- Binner (Dictionary)< 1 %
- Bootstrap Sampling< 1 %
- Number to Category (Apply)< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Denormalizer (PMML)< 1 %
- Numeric Row Splitter< 1 %
String Replace (Dictionary)< 1 %- Unpivot< 1 %
- Single sample t-test< 1 %
CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
- Crosstab< 1 %
- Box Plot (legacy)< 1 %
- DB Merge< 1 %
- DB Writer< 1 %
- Random Label Assigner< 1 %
- Stresser< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Model Loop End< 1 %
Excel Sheet Appender (XLS)< 1 %- Radar Plot Appender< 1 %
- Term Co-Occurrence Counter< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Modifiable Term Filter< 1 %
- Porter Stemmer< 1 %
- RegEx Filter< 1 %
- Flat File Document Parser< 1 %
Bag of Words Creator< 1 %- Sentence Extractor< 1 %
- Strings to Document< 1 %
- Weka Predictor (3.7)< 1 %
- Column Filter (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Columns to JSON< 1 %
- Gaussian Convolution< 1 %
MongoDB Reader< 1 %- Python Edit Variable (legacy)< 1 %
- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Time Field Extractor (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Twitter Search< 1 %
- Twitter Timeline< 1 %
- Twitter Post Tweet< 1 %
- Row Splitter (col+)< 1 %
- RDKit Salt Stripper< 1 %
- Run Garbage Collector< 1 %
- Benchmark End (3 ports)< 1 %
- Catch Errors (Data Ports)< 1 %
Table Row to Variable< 1 %- Variable Creator< 1 %
- Counting Loop Start< 1 %
- Scorer< 1 %
- Lag Column< 1 %
- Table Difference Finder< 1 %
- Value Counter< 1 %
CASE Switch Variable (End)< 1 %- Spark to Table< 1 %
- Molecule Type Cast< 1 %
- Empty Table Creator< 1 %
- H2O Random Forest Learner (Regression)< 1 %
- Java Snippet Row Splitter< 1 %
- Credentials Configuration< 1 %
- List Box Input (legacy)< 1 %
- JSON to XML< 1 %
- Python Script (legacy)< 1 %
- R to Table< 1 %
- Date&Time Part Extractor< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Molecule Fragmenter< 1 %
Location Extractor< 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.