This loop starting node iterates over a list of columns of the input table. Its columns are divided into two sets, the "excluded" columns will always be included in any iteration, the "included" columns will be visible once in each iteration.
Options
Popular Predecessors
- Column Filter7 %
- Column Splitter4 %
Cell Splitter3 %Table Row to Variable3 %Number To String3 %String To Number2 %- Table Transposer2 %
- Excel Reader2 %
Row Filter (deprecated)2 %- Cell Splitter1 %
- GroupBy1 %
Joiner1 %- Joiner1 %
Table Column to Variable1 %Variable to Table Column1 %- RowID1 %
- Missing Value1 %
- Loop End1 %
- Column Appender< 1 %
- String Manipulation< 1 %
- String to Number< 1 %
- Line Plot (JavaScript)< 1 %
- Group Loop Start< 1 %
- Table Creator< 1 %
- String Manipulation (Multi Column)< 1 %
- Column Resorter< 1 %
Concatenate (Optional in)< 1 %- Math Formula< 1 %
- List Files/Folders< 1 %
- Column Name Extractor< 1 %
- Missing Value Column Filter< 1 %
- Pivot< 1 %
Column Rename< 1 %- Sorter< 1 %
- XPath< 1 %
- Number to String< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
Column Filter Configuration< 1 %- Concatenate< 1 %
- Reference Column Filter< 1 %
- Ungroup< 1 %
XLS Reader< 1 %- Unpivot< 1 %
- Split Collection Column< 1 %
Variable to Table Row< 1 %- Column Renamer (Dictionary)< 1 %
Row Splitter (deprecated)< 1 %- Table Row to Variable Loop Start< 1 %
- Column Combiner< 1 %
- Rule-based Row Splitter< 1 %
- Math Formula (Multi Column)< 1 %
- CSV Reader< 1 %
- Column List Loop Start< 1 %
- Column Rename (Regex)< 1 %
Excel Reader (XLS)< 1 %Python Script (1⇒1)< 1 %- Lag Column< 1 %
- Column Expressions< 1 %
- Table Column to Variable< 1 %
CSV Writer< 1 %List Files< 1 %- Chunk Loop Start< 1 %
Merge Variables< 1 %- String Matcher< 1 %
Variable to Table Column< 1 %- Reference Column Splitter< 1 %
- Normalizer< 1 %
- Row Sampling< 1 %
- Box Plot (legacy)< 1 %
- Column Filter (legacy)< 1 %
- Loop End (Column Append)< 1 %
- Constant Value Column< 1 %
- Reference Row Filter< 1 %
- Data Generator< 1 %
- Integer Input (legacy)< 1 %
- Python Script (legacy)< 1 %
Counting Loop Start< 1 %- Auto-Binner< 1 %
- One to Many< 1 %
- Double to Integer< 1 %
- Equal Size Sampling< 1 %
- Number Rounder< 1 %
- Value Counter< 1 %
- Extract Variables (Data)< 1 %
- Column Filter Configuration< 1 %
- Table View (JavaScript)< 1 %
- Variable to Table Column< 1 %
- Table Row to Variable< 1 %
- Rule Engine (Dictionary)< 1 %
- XLS Control Table Generator< 1 %
Generic Loop Start< 1 %- Column Aggregator< 1 %
- Extract Time Window (legacy)< 1 %
- Create Directory (legacy)< 1 %
- Constant Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Column Selection Configuration< 1 %
- Variable Creator< 1 %
- Table Manipulator< 1 %
- Column Renamer< 1 %
- DB Insert< 1 %
- Breakpoint< 1 %
- Wait...< 1 %
Loop End< 1 %- Cross Joiner< 1 %
- Low Variance Filter< 1 %
- Numeric Row Splitter< 1 %
- String Manipulation (Variable)< 1 %
- Cache< 1 %
- SDF Reader< 1 %
- Empty Table Creator< 1 %
- Logistic Regression Predictor< 1 %
- Duplicate Row Filter< 1 %
- Reference Column Resorter< 1 %
- DB Query Reader< 1 %
- Columns to JSON< 1 %
- Moving Aggregator< 1 %
- Variable to Table Row< 1 %
- Counting Loop Start< 1 %
- Merge Variables< 1 %
- Path to String< 1 %
- Row to Column Names< 1 %
- Excel Writer< 1 %
- String to URI< 1 %
- Try (Data Ports)< 1 %
- Inject Variables (Data)< 1 %
File Reader< 1 %- Java Edit Variable< 1 %
- Java Snippet< 1 %
Recursive Loop End (2 ports)< 1 %- Numeric Binner< 1 %
- Column Auto Type Cast< 1 %
- Column Merger< 1 %
- Correlation Filter< 1 %
- Domain Calculator< 1 %
- Partitioning< 1 %
- String Replacer< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- Color Manager< 1 %
- Molecule Type Cast< 1 %
- Parallel Chunk Start< 1 %
- Counter Generation< 1 %
- Math Formula (Variable)< 1 %
- Bag Of Words Creator< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- String to Date&Time< 1 %
- Benchmark Start< 1 %
- Nominal Value Row Filter< 1 %
- Rank< 1 %
- IF Switch< 1 %
- DB Reader< 1 %
- Variable Expressions< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Boolean Configuration< 1 %
- Column Filter Widget< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- File Reader< 1 %
- File Reader (Complex Format)< 1 %
- Table Reader< 1 %
- Generic Loop Start< 1 %
- Variable Loop End< 1 %
- CASE Switch Start< 1 %
- Read Excel Sheet Names< 1 %
- Date&Time Part Extractor< 1 %
- RDKit R-Group Decomposition< 1 %
- Recursive Loop Start< 1 %
- Call Workflow Service< 1 %
- Multiple Selection Configuration< 1 %
- MongoDB Reader< 1 %
- R Snippet< 1 %
Table Row To Variable Loop Start< 1 %Linear Correlation< 1 %Double To Int< 1 %CASE Switch Data (Start)< 1 %- String to JSON< 1 %
Python Script (1⇒1)< 1 %- R to Table< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit To Molecule< 1 %
Table Row to Variable< 1 %- Case Converter< 1 %
- Numeric Outliers< 1 %
- Extract Table Dimension< 1 %
- Table Editor (JavaScript)< 1 %
- SMARTS Query< 1 %
- Create Collection Column< 1 %
- URL to File Path< 1 %
Recursive Loop End< 1 %Column Appender< 1 %Excel Reader (XLS)< 1 %- String Input (legacy)< 1 %
- R Source (Table)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %Table Writer< 1 %- k-Means< 1 %
- Create Table Structure< 1 %
- Rule Engine Variable< 1 %
- Java IF (Table)< 1 %
- Nominal Row Filter Configuration< 1 %
- Integer Configuration< 1 %
- Don't Save Start< 1 %
- Node Adjacency Matrix< 1 %
Python Script (2⇒1)< 1 %- POST Request< 1 %
- Modify Time< 1 %
- Moving Average< 1 %
- RDKit From Molecule< 1 %
- Image Converter< 1 %
- Image Normalizer< 1 %
CSV Reader< 1 %Recursive Loop Start< 1 %- Column to Grid< 1 %
- HiLite Row Splitter< 1 %
Number To String (PMML)< 1 %- Average Filter< 1 %
- Median Filter< 1 %
- SubGraph Extractor< 1 %
Python Script (2⇒1)< 1 %- RDKit Descriptor Calculation< 1 %
- MolConverter< 1 %
- List Remote Files (legacy)< 1 %
Table Column to Variable< 1 %Database Connection Table Reader< 1 %Database Looping< 1 %Interval Loop Start< 1 %- Hierarchical Clustering< 1 %
- PCA Apply< 1 %
- Linear Correlation< 1 %
- Table Validator< 1 %
- Top k Row Filter< 1 %
- Numeric Outliers (Apply)< 1 %
- Save Workflow< 1 %
- DB Table Selector< 1 %
- String Configuration< 1 %
- Table to JSON< 1 %
JSON Reader< 1 %- Splitter (uncropped)< 1 %
- Python Source (legacy)< 1 %
- Table Difference Checker< 1 %
- Disturber Node< 1 %
- Molecular Properties< 1 %
- Fingerprints< 1 %
- Substructure Search< 1 %
- RDKit Fingerprint< 1 %
- Find Elements< 1 %
String Replace (Dictionary)< 1 %CASE Switch Variable (End)< 1 %- Normalize Plates (NPI)< 1 %
- Vector Length Normalization< 1 %
- ARFF Reader< 1 %
Database Reader< 1 %- Fixed Width File Reader< 1 %
Table Reader< 1 %Recursive Loop Start (2 ports)< 1 %Variable Loop End< 1 %- X-Aggregator< 1 %
PCA Apply< 1 %PCA< 1 %- Random Forest Learner (Regression)< 1 %
- Add Empty Rows< 1 %
- Auto-Binner (Apply)< 1 %
Cell Replacer< 1 %- Category to Number< 1 %
- Nominal Value Row Splitter< 1 %
- Statistics< 1 %
- Extract Table Spec< 1 %
- ROC Curve (legacy)< 1 %
- Fingerprint Bayesian Predictor< 1 %
- Parallel Chunk End< 1 %
Read XLS Sheet Names< 1 %Read Excel Sheet Names (XLS)< 1 %- Java Snippet (simple)< 1 %
- Java Edit Variable (simple)< 1 %
- Case Converter< 1 %
- Word Parser< 1 %
Document vector< 1 %- Term to String< 1 %
- Column Selection (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Global Thresholder< 1 %
- Parameter Optimization Loop Start< 1 %
Python Source< 1 %- R Snippet< 1 %
- Create Date&Time Range< 1 %
- Remove Empty Rows< 1 %
- Molecule to CDK< 1 %
- RDKit Substructure Filter< 1 %
- WAV Reader< 1 %
- Component Separator< 1 %
- TIBCO Spotfire File Reader< 1 %
- Is Empty< 1 %
Flow Variable IF Switch< 1 %- List Folders< 1 %
- Save File Locally< 1 %
- PDB SMILES Query< 1 %
- Copy/Move Files (legacy)< 1 %
- File Meta Info (legacy)< 1 %
- URI Port to Variable< 1 %
- Read Images< 1 %
Line Reader< 1 %Line Reader< 1 %- Feature Selection Loop End< 1 %
Loop End (2 ports)< 1 %- Decision Tree Predictor< 1 %
- Tree Ensemble Statistics< 1 %
- Expand Bit Vector< 1 %
- Cell Splitter By Position< 1 %
- Many to One< 1 %
- CAIM Binner< 1 %
- Edit Nominal Domain< 1 %
- Row Filter (Labs)< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
- String to Number (PMML)< 1 %
- Target Shuffling< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Linear Discriminant Analysis Apply< 1 %
CASE Switch Data (End)< 1 %- Create Temp Dir (legacy)< 1 %
- Random Label Assigner< 1 %
- Visual 2D Data Generator< 1 %
DL Network Executor< 1 %- Line Plot (Plotly)< 1 %
- PMML to Cell< 1 %
- External Tool< 1 %
- Java Snippet Row Filter< 1 %
- Tika Language Detector< 1 %
- String to Term< 1 %
- Google Sheets Reader< 1 %
- Boolean Input (legacy)< 1 %
- File Chooser (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Column Selection Widget< 1 %
- Container Input (Table)< 1 %
- Container Input (JSON)< 1 %
- Image to DataRow< 1 %
- Parameter Optimization Loop End< 1 %
Column Filter QuickForm (legacy)< 1 %Column Selection QuickForm (legacy)< 1 %- R Predictor< 1 %
- GET Request< 1 %
- Date&Time Difference< 1 %
Extract Date&Time Fields< 1 %- Window Loop Start< 1 %
- Mask Date/Time (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Column to XML< 1 %
- XML Row Combiner< 1 %
- Row Splitter (col+)< 1 %
- Quit WebDriver< 1 %
- List To Set< 1 %
- MolImporter< 1 %
- Interval Loop Start< 1 %
Variable Condition Loop End< 1 %- Recursive Loop End< 1 %
- X-Partitioner< 1 %
- Column Comparator< 1 %
- Set Operator< 1 %
- Shuffle< 1 %
- Renderer to Image< 1 %
- CASE Switch End< 1 %
- Keras Network Executor< 1 %
- OpenBabel< 1 %
- RegEx Filter< 1 %
- Tika Parser< 1 %
- Strings to Document< 1 %
- Files/Folders Meta Info< 1 %
- ROC Curve (JavaScript)< 1 %
- Refresh Button Widget< 1 %
- PNG Image to ImgPlus< 1 %
- Modify Date< 1 %
- RDKit MCS< 1 %
Views
- This node has no views
Workflows
_Looping_over_all_columns_and_manipulation_of_each 1KNIME Forum- !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
- (3D) Fragment library design workflowKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
- Show all 929 workflows
Links
- KNIME E-Learning Course: Section 7.2. Re-executing Workflow Parts: Loopswww.knime.com/knime-introductory-course/chapter7/section2
- Cut and Paste to Excel (difficulties with decimal separator)by armingrudd on 2019-04-10forum.knime.com/p/58468
- How to include namespace information and prefix on some elements on a XML column?by armingrudd on 2019-10-17forum.knime.com/p/72528
- How can I transform all my Columns in order that they have only binary values?by ipazin on 2019-02-06forum.knime.com/p/54199
- Change all stringsby armingrudd on 2020-01-20forum.knime.com/p/79245
- Show all 8 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.