This node adds a new column to an input data table which contains a counter. The minimum value and the step size of the counter can be adjusted. The input data is not changed. The most wished behavior is that the minimum value (so the value appended to the first row) is set to 1 and the step size to one as well. This results in appending the row number to the initial data table.
Options
Popular Predecessors
- Sorter8 %
- Group Loop Start4 %
- GroupBy4 %
Row Filter (deprecated)3 %- Empty Table Creator3 %
- Column Filter2 %
CSV Reader2 %- Concatenate2 %
- Excel Reader2 %
- Duplicate Row Filter2 %
- Value Counter2 %
Table Row to Variable2 %- Joiner2 %
- Table Creator2 %
Column Rename1 %Row Splitter (deprecated)1 %- String Manipulation1 %
- Rule-based Row Filter1 %
- String to Number1 %
- RowID< 1 %
- Missing Value< 1 %
- Constant Value Column< 1 %
Concatenate (Optional in)< 1 %- Table Transposer< 1 %
- CSV Reader< 1 %
- Column Resorter< 1 %
- Rule Engine< 1 %
- Weka Predictor (3.7)< 1 %
List Files< 1 %String To Number< 1 %- Add Empty Rows< 1 %
- Create Date&Time Range< 1 %
- XPath< 1 %
- Column Expressions< 1 %
Excel Reader (XLS)< 1 %- Cell Splitter< 1 %
Table Column to Variable< 1 %- Chunk Loop Start< 1 %
- Math Formula< 1 %
Generic Loop Start< 1 %- MultiLayerPerceptron Predictor< 1 %
- Reference Row Filter< 1 %
- Java Snippet (simple)< 1 %
Variable to Table Row< 1 %XLS Reader< 1 %- Loop End< 1 %
- Lag Column< 1 %
- String to Date&Time< 1 %
- Variable to Table Row< 1 %
Loop End< 1 %Counting Loop Start< 1 %- JSON to Table< 1 %
- RDKit From Molecule< 1 %
- File Reader< 1 %
- Substructure Matcher< 1 %
- Column Aggregator< 1 %
- Cross Joiner< 1 %
- Rule-based Row Splitter< 1 %
Python Script (1⇒1)< 1 %Database Connection Table Reader< 1 %- Case Converter< 1 %
- Shuffle< 1 %
- Molecule Type Cast< 1 %
- Math Formula (Variable)< 1 %
- Load SD-Files (SDF)< 1 %
- Reference Row Splitter< 1 %
- Pivot< 1 %
- End IF< 1 %
- Nominal Row Filter Widget< 1 %
Recursive Loop End< 1 %- Decision Tree Predictor< 1 %
- Column Combiner< 1 %
Column Appender< 1 %- Column Rename (Regex)< 1 %
- Nominal Value Row Filter< 1 %
- Rank< 1 %
- R Snippet< 1 %
- Random Numbers Generator< 1 %
Excel Reader (XLS)< 1 %- Integer Configuration< 1 %
- Column Filter (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Breakpoint< 1 %
- Line Reader< 1 %
- Variable Expressions< 1 %
- List Box Configuration< 1 %
Variable to Table Column< 1 %- Loop End (Column Append)< 1 %
- Random Forest Predictor< 1 %
- Partitioning< 1 %
- String Replacer< 1 %
- Ungroup< 1 %
- Sentence Extractor< 1 %
- Date&Time Difference< 1 %
- Date&Time to String< 1 %
- Moving Aggregator< 1 %
Table Reader< 1 %- String Manipulation (Multi Column)< 1 %
- Numeric Outliers< 1 %
- JSON Path< 1 %
- Python Source (legacy)< 1 %
- Molecular Properties< 1 %
- Table Row to Variable< 1 %
- Column Appender< 1 %
- Table Validator (Reference)< 1 %
- Parallel Chunk Start< 1 %
- Table View (JavaScript)< 1 %
- Column Renamer< 1 %
- Column List Loop Start< 1 %
- Auto-Binner< 1 %
- Column Auto Type Cast< 1 %
- Create Table Structure< 1 %
- String Splitter (Regex)< 1 %
- SDF Reader< 1 %
- One Row to Many< 1 %
- Random Label Assigner< 1 %
- RDKit Add Hs< 1 %
- ARIMA Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Random Number Assigner< 1 %
- Variable to Table Column< 1 %
- Table Column to Variable< 1 %
- Recursive Loop Start< 1 %
- IF Switch< 1 %
- Line Plot (JavaScript)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date&Time Part Extractor< 1 %
- String to Path< 1 %
- RDKit Optimize Geometry< 1 %
- Recursive Loop End< 1 %
- Regex Extractor< 1 %
- MarvinSketch< 1 %
- Split Collection Column< 1 %
File Reader< 1 %- Java Snippet< 1 %
Recursive Loop Start< 1 %Cell Replacer< 1 %- Column Renamer (Dictionary)< 1 %
Joiner< 1 %- Number Rounder< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- Empty Table Switch< 1 %
- Extract Table Spec< 1 %
- Data Generator< 1 %
- Counter Generation< 1 %
- Java Edit Variable (simple)< 1 %
- Date&Time Shift< 1 %
- RDKit Canon SMILES< 1 %
- RDKit To InChI< 1 %
- Normalize Plates (Z-Score)< 1 %
- Regression Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Number to String< 1 %
- Filter Apply< 1 %
- Nominal Value Row Splitter< 1 %
- String Manipulation (Variable)< 1 %
- Unpivot< 1 %
- Statistics< 1 %
- Cache< 1 %
- Parallel Chunk End< 1 %
- DB Reader< 1 %
- DB Query Reader< 1 %
- Unique Term Extractor< 1 %
- Scatter Plot (JavaScript)< 1 %
- Date&Time-based Row Filter< 1 %
- Time Difference (legacy)< 1 %
- Remove Empty Rows< 1 %
- File Reader (Complex Format)< 1 %
- Table Reader< 1 %
- Counting Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Table Manipulator< 1 %
- Rule Engine Variable< 1 %
- DB Delete (Table)< 1 %
- Read Excel Sheet Names< 1 %
- List Files/Folders< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Selection Configuration< 1 %
- Python Script (legacy)< 1 %
- H2O Gradient Boosting Machine Learner (Regression)< 1 %
- CASE Switch Start< 1 %
- Reference Column Resorter< 1 %
- Table Validator< 1 %
- Top k Row Filter< 1 %
- Data Explorer< 1 %
- Fixed Width File Reader< 1 %
- Wait...< 1 %
- Tile View (JavaScript)< 1 %
- DB Writer< 1 %
- String Replacer (Dictionary)< 1 %
Database Looping< 1 %Cell Splitter< 1 %Number To String< 1 %- Column Name Extractor< 1 %
- One to Many< 1 %
- Extract Table Dimension< 1 %
- Window Loop Start< 1 %
- String to Date/Time (legacy)< 1 %
- Create Collection Column< 1 %
Variable to Table Row< 1 %Scorer< 1 %- TimeDelay Loop End< 1 %
- Time Series Generator< 1 %
- Math Formula (Multi Column)< 1 %
- Category to Number< 1 %
- Extract Variables (Data)< 1 %
Database Reader< 1 %- Beta Distributed Assigner< 1 %
- RDKit Substructure Filter< 1 %
Line Reader< 1 %- Gaussian Distributed Assigner< 1 %
- Dictionary Tagger< 1 %
- Document Data Extractor< 1 %
- Term to String< 1 %
- Integer Input (legacy)< 1 %
- RDKit Molecule Substructure Filter< 1 %
- Random Forest Predictor (Regression)< 1 %
- Normalizer< 1 %
- Number to String (PMML)< 1 %
- Similarity Search< 1 %
- Inject Variables (Data)< 1 %
- ARFF Reader< 1 %
Database Writer< 1 %- Tree Ensemble Predictor< 1 %
- Column to Grid< 1 %
- Missing Value Column Filter< 1 %
String Replace (Dictionary)< 1 %- Color Manager< 1 %
- Gamma Distributed Assigner< 1 %
- TimeDelay Loop Start< 1 %
- Parameter Optimization Loop Start< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- RDKit Fingerprint< 1 %
- Fragments to MMPs< 1 %
- Plate Row Converter< 1 %
- MolConverter< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Line Reader< 1 %Recursive Loop End (2 ports)< 1 %- Naive Bayes Predictor< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Cell Splitter By Position< 1 %
- Create Temp Dir (legacy)< 1 %
- Random Item Inserter< 1 %
- Random Number Assigner (Apache)< 1 %
- Google Sheets Reader< 1 %
- Columns to JSON< 1 %
- Moving Average< 1 %
- Fingerprints< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Substructure Counter< 1 %
Table Extractor< 1 %- Plate Well IDs< 1 %
- Generic Loop Start< 1 %
CASE Switch Data (Start)< 1 %- Merge Variables< 1 %
- String Matcher< 1 %
- Interactive Value Filter Widget< 1 %
- Integer Widget< 1 %
- R Source (Table)< 1 %
- RDKit Chemical Transformation< 1 %
Fragments to MMPs< 1 %- Download / Upload from List (legacy)< 1 %
- List Remote Files (legacy)< 1 %
Table Row To Variable Loop Start< 1 %- Read Images< 1 %
- Java Edit Variable< 1 %
PCA Apply< 1 %- Binner (Dictionary)< 1 %
- Column Merger< 1 %
- Low Variance Filter< 1 %
- Box Plot (legacy)< 1 %
Excel Reader (XLS)< 1 %- Tika Parser< 1 %
- Rowset Filter< 1 %
Python Script (1⇒1)< 1 %Python Source< 1 %Python Script (1⇒2)< 1 %Extract Date&Time Fields< 1 %- Extract Time Window (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Twitter Search< 1 %
- Substructure Search< 1 %
RDKit Functional Group Filter< 1 %- RDKit Salt Stripper< 1 %
- Feature Remover< 1 %
- InChi< 1 %
IF Switch (Flow Variable Value)< 1 %- Range Splitter< 1 %
- MolSearch< 1 %
- Standardizer< 1 %
- Desirability Ranking< 1 %
Binary Objects to Files< 1 %- Try (Data Ports)< 1 %
- Try (Variable Ports)< 1 %
Table Column to Variable< 1 %Interval Loop Start< 1 %Variable Condition Loop End< 1 %Recursive Loop Start (2 ports)< 1 %Variable Loop End< 1 %- X-Partitioner< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- k-Means< 1 %
- K Nearest Neighbor< 1 %
PCA< 1 %Regression Predictor< 1 %- Numeric Scorer< 1 %
Gradient Boosted Trees Predictor< 1 %- Distance Matrix Pair Extractor< 1 %
- Numeric Binner< 1 %
- Double to Integer< 1 %
- Constant Value Column Filter< 1 %
- Row Filter (Labs)< 1 %
- Denormalizer< 1 %
- Renderer to Image< 1 %
- Timer Info< 1 %
- DB Update< 1 %
- Conditional Label Assigner< 1 %
- Random Label Assigner (Data)< 1 %
- Random Matcher< 1 %
- H2O to Table< 1 %
- Association Rule Learner (Borgelt)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Markup Tag Filter< 1 %
- Double Input (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Container Input (Table)< 1 %
- String to JSON< 1 %
- Image to DataRow< 1 %
- Image Converter< 1 %
- R to Table< 1 %
- RDKit Add Conformers< 1 %
- RDKit Molecule Extractor< 1 %
- RDKit One Component Reaction< 1 %
- RDKit To Molecule< 1 %
- RDKit Two Component Reaction< 1 %
- Window Slider< 1 %
- Murcko Scaffold< 1 %
- Slack Users Lookup By Email< 1 %
Flow Variable End IF< 1 %- PDB Connector Query Executor< 1 %
- Number Formatter< 1 %
- Advanced MolConverter< 1 %
- String to URI< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Filter Apply Row Splitter< 1 %
- HiLite Row Splitter< 1 %
- Set Operator< 1 %
- Target Shuffling< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- CASE Switch End< 1 %
CASE Switch Data (End)< 1 %- SDF Stripper< 1 %
- PDF Parser< 1 %
- Path to String< 1 %
- Path to String (Variable)< 1 %
SAP Reader (Theobald Software)< 1 %- XGBoost Predictor (Regression)< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
- 00 Main MenuKNIME Hub
- 00 Main MenuKNIME Hub
- Show all 1217 workflows
Links
- create date range from date columnby armingrudd on 2020-02-23forum.knime.com/p/82426
- Create a. new column with with a fixed number of rows as obtained from the table row to variable nodeby izaychik63 on 2020-12-22forum.knime.com/p/111796
- Add value to columnby HansS on 2021-09-09forum.knime.com/p/133950
- Add Line Columnby armingrudd on 2019-04-15forum.knime.com/p/58746
- Appending Unique Identifiers in multiple branchesby armingrudd on 2020-04-21forum.knime.com/p/88388
- 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.