This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementTable Row to VariableThis node uses the first row of a data table to define new flow variables. The names of the variables are defined by the column names and the variable assignments (i.e. the values) are given by the values in the row. The variables are exposed using a variables out connection.
Options
Popular Successors
- Partitioning2 %
- Table Transposer2 %
Parquet Writer2 %- RowID1 %
- File Download (legacy)1 %
- K Nearest Neighbor1 %
- RProp MLP Learner1 %
Python Script (1⇒1)1 %- Empty Table Creator< 1 %
- Rule Engine< 1 %
Counting Loop Start< 1 %- Math Formula (Variable)< 1 %
- Breakpoint< 1 %
- Delete Files (legacy)< 1 %
- Rule Engine Variable< 1 %
- DB Query Reader< 1 %
- RDKit Substructure Filter< 1 %
Database Table Selector< 1 %- Get Pooled WebDriver< 1 %
- Java Edit Variable< 1 %
- Gradient Boosted Trees Learner< 1 %
Excel Reader (XLS)< 1 %- Keras Input Layer< 1 %
Container Input (Variable)< 1 %- RDKit R-Group Decomposition< 1 %
Table Column to Variable< 1 %Recursive Loop End (2 ports)< 1 %Table Reader< 1 %- Line Plot (Plotly)< 1 %
- List Box Configuration< 1 %
- DB Connector< 1 %
- Variable Expressions< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Google Sheets Updater< 1 %
- Multiple Selection Widget< 1 %
- POST Request< 1 %
- Naive Bayes Learner< 1 %
- Random Forest Learner (Regression)< 1 %
- DB Insert< 1 %
- Scatter Plot (JavaScript)< 1 %
- JSON Path< 1 %
- Feature Selection Loop End< 1 %
- Auto-Binner< 1 %
- Column Rename (Regex)< 1 %
Row Filter (deprecated)< 1 %- Python Edit Variable (legacy)< 1 %
- Moving Average< 1 %
- PDB Saver< 1 %
Table Row to Variable< 1 %Database Reader< 1 %- Java Snippet< 1 %
- Constant Value Column< 1 %
- DB Merge< 1 %
- Value Selection Widget< 1 %
XGBoost Tree Ensemble Learner (Regression)< 1 %Database Writer< 1 %Recursive Loop End< 1 %Recursive Loop Start< 1 %- Logistic Regression Learner< 1 %
- Simple Regression Tree Learner< 1 %
JSON Writer< 1 %- R Learner< 1 %
- Date&Time Difference< 1 %
- Moving Aggregator< 1 %
- Copy/Move Files (legacy)< 1 %
- Wait...< 1 %
Table Row to Variable< 1 %Image Writer (Port)< 1 %- GroupBy< 1 %
- Index Query< 1 %
- Java Edit Variable (simple)< 1 %
- Multiple Selection Configuration< 1 %
- SSH Connection (legacy)< 1 %
CSV Writer< 1 %Variable Loop End< 1 %- Microsoft SQL Server Connector< 1 %
- Random Number Assigner< 1 %
- Google Analytics Query (legacy)< 1 %
- Text Output Widget (legacy)< 1 %
- Parameter Optimization Loop End< 1 %
- Python Object Reader (legacy)< 1 %
- Filter Apply< 1 %
- Row Filter (Labs)< 1 %
- String Manipulation (Variable)< 1 %
- Merge Variables< 1 %
- Keras Dense Layer< 1 %
- PDF Parser< 1 %
- External Tool (Labs)< 1 %
- Single Selection Widget< 1 %
Python Object Reader< 1 %Python Script (1⇒2)< 1 %- Start WebDriver< 1 %
Flow Variable End IF< 1 %- Run Garbage Collector< 1 %
Binary Objects to Files< 1 %- Active Branch Inverter< 1 %
- Feature Selection Filter< 1 %
- Group Loop Start< 1 %
- PCA Apply< 1 %
- Missing Value< 1 %
- Rule-based Row Filter< 1 %
- Create Temp Dir (legacy)< 1 %
- SDF Reader< 1 %
- Scatter Plot (Plotly)< 1 %
Excel Writer (XLS)< 1 %- Google Sheets Reader< 1 %
- Integer Configuration< 1 %
- Single Selection Configuration< 1 %
- WebDriver Factory< 1 %
- Find Elements< 1 %
- KNIME Server Connection (legacy)< 1 %
- Load SD-Files (SDF)< 1 %
- ARIMA Learner< 1 %
- URL to File Path (Variable)< 1 %
Variable to Table Column< 1 %Database Connector< 1 %Model Reader< 1 %Column Rename< 1 %- String Replacer< 1 %
- IF Switch< 1 %
- SQLite Connector< 1 %
Excel Reader (XLS)< 1 %JSON Reader< 1 %- R Source (Table)< 1 %
- Date&Time-based Row Filter< 1 %
Write MDB< 1 %Flow Variable IF Switch< 1 %- List Folders< 1 %
- Download (legacy)< 1 %
- Download / Upload from List (legacy)< 1 %
- URL to File Path< 1 %
Table Row To Variable Loop Start< 1 %- Duplicate Row Filter< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Data (Start)< 1 %- Spark Column Filter< 1 %
- SDF Writer< 1 %
- Parameterized DB Query Reader< 1 %
- Explorer Browser< 1 %
- Line Plot (JavaScript)< 1 %
- List Box Widget< 1 %
- Python View (legacy)< 1 %
- GET Request< 1 %
- String to Date&Time< 1 %
- Twitter API Connector< 1 %
- RDKit One Component Reaction< 1 %
Send Keys< 1 %- Write Variables< 1 %
- Unzip Files (legacy)< 1 %
- Upload (legacy)< 1 %
- Create File Name (legacy)< 1 %
- Inject Variables (Data)< 1 %
Variable to Table Row< 1 %- Table to Image< 1 %
List Files< 1 %Loop End< 1 %- Numeric Scorer< 1 %
- Column Resorter< 1 %
- Reference Column Filter< 1 %
- Reference Row Splitter< 1 %
- Value Counter< 1 %
CASE Switch Variable (Start)< 1 %- Crosstab< 1 %
- PostgreSQL Connector< 1 %
DB Table Creator< 1 %- DB Table Selector< 1 %
Table to PDF< 1 %Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Filter< 1 %
- Nominal Row Filter Configuration< 1 %
- String Configuration< 1 %
- Python Source (legacy)< 1 %
- Date&Time Shift< 1 %
- Twitter Search< 1 %
- XML Column Combiner< 1 %
XML Reader< 1 %- XPath< 1 %
- RDKit Interactive Table< 1 %
- RDKit R-Group Decomposition (deprecated)< 1 %
- Text Classifier Learner< 1 %
- Load Text Files< 1 %
- Create Collection Column< 1 %
- Create Directory (legacy)< 1 %
CSV Reader< 1 %Database SQL Executor< 1 %- CSV Reader< 1 %
- CSV Writer< 1 %
File Reader< 1 %- Table Creator< 1 %
Variable Condition Loop End< 1 %- k-Means< 1 %
- DBSCAN< 1 %
- Gradient Boosted Trees Learner (Regression)< 1 %
- Random Forest Learner< 1 %
- Concatenate< 1 %
- Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
Row Splitter (deprecated)< 1 %- Numeric Row Splitter< 1 %
- Sorter< 1 %
- String Manipulation< 1 %
String Replace (Dictionary)< 1 %- Unpivot< 1 %
- Rule-based Row Splitter< 1 %
- Empty Table Switch< 1 %
Merge Variables< 1 %- Send Email< 1 %
- Hive Connector< 1 %
Parquet Reader< 1 %- Capture Workflow End< 1 %
- Mol2 Reader< 1 %
- Amazon S3 Connection (legacy)< 1 %
- Amazon S3 File Picker (legacy)< 1 %
- Oracle Connector< 1 %
- DB SQL Executor< 1 %
- DB Row Filter< 1 %
- DB Query< 1 %
- Similarity Search< 1 %
- Keras Network Learner< 1 %
- Column Expressions< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
Read Excel Sheet Names (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Google Authenticator (API Key)< 1 %- Multiple Selections (legacy)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Network Analyzer< 1 %
- R Snippet< 1 %
- Create Date&Time Range< 1 %
- Modify Date< 1 %
- String to Date/Time (legacy)< 1 %
XML Writer< 1 %- RDKit Descriptor Calculation< 1 %
- RDKit Two Component Reaction< 1 %
- MarvinSketch< 1 %
- Active Learning Loop End< 1 %
- HTTPS Connection (legacy)< 1 %
- Extract Variables (Data)< 1 %
Variable to Table Row< 1 %- Loop End (Column Append)< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
Recursive Loop Start (2 ports)< 1 %Column Appender< 1 %- Column Renamer (Dictionary)< 1 %
- Table Validator (Reference)< 1 %
- Filter Apply Row Splitter< 1 %
- Row Sampling< 1 %
Amazon Athena Connector< 1 %- Amazon Redshift Connector< 1 %
Microsoft SQL Server Connector< 1 %- DB Writer< 1 %
- One Row to Many< 1 %
- DL Python Network Editor< 1 %
- Tag Filter< 1 %
- Tika Parser< 1 %
- Word Parser< 1 %
- CSS Editor< 1 %
- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
- String Widget< 1 %
- Table to JSON< 1 %
R Model Reader< 1 %- Webpage Retriever< 1 %
- Time Generator (legacy)< 1 %
- Table to HTML String< 1 %
- HTTP Retriever< 1 %
- HTML Parser< 1 %
- Quit WebDriver< 1 %
- Wait< 1 %
- XLS Border Formatter< 1 %
- Load Local PDB Files< 1 %
- Notched Boxplot (JFreechart)< 1 %
- Elasticsearch Reader (ES 6)< 1 %
- Catch Errors (Var Ports)< 1 %
- Try (Variable Ports)< 1 %
Image Writer (Table Column)< 1 %Database Looping< 1 %- Fixed Width File Reader< 1 %
PMML Reader< 1 %- Feature Selection Loop Start (1:1)< 1 %
- X-Aggregator< 1 %
- Linear Regression Learner< 1 %
- Polynomial Regression Learner< 1 %
- SMOTE< 1 %
- SVM Learner< 1 %
- Numeric Binner< 1 %
- Linear Correlation< 1 %
- Create Table Structure< 1 %
- Subset Matcher< 1 %
- Normalizer< 1 %
- Reference Column Resorter< 1 %
- Column Splitter< 1 %
- String Manipulation (Multi Column)< 1 %
- Top k Row Filter< 1 %
- Renderer to Image< 1 %
- Rule Engine Variable (Dictionary)< 1 %
CASE Switch Data (End)< 1 %- Impala Connector< 1 %
- Molecule Type Cast< 1 %
- Mol2 Writer< 1 %
- Amazon Translate< 1 %
- Azure Blob Store Connection (legacy)< 1 %
- MySQL Connector< 1 %
- DB Connection Extractor< 1 %
- DB Delete (Table)< 1 %
- DB Column Filter< 1 %
- DB Table Remover< 1 %
- Random Item Inserter< 1 %
- PMML Ensemble Loop End< 1 %
- Generic Web Service Client< 1 %
- H2O Gradient Boosting Machine Learner< 1 %
- Interval Chart (JFreeChart)< 1 %
- SAS7BDAT Reader< 1 %
- Java Snippet (simple)< 1 %
- Google Sheets Connector< 1 %
- Google Cloud Storage File Picker (legacy)< 1 %
- Credentials Configuration< 1 %
- Value Filter (legacy)< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- JSON Transformer< 1 %
- Data Row to Image< 1 %
- Image Viewer< 1 %
- Rowset Filter< 1 %
- Table to R< 1 %
- Date&Time to String< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Modify Time Zone< 1 %
XGBoost Tree Ensemble Learner< 1 %- RDKit Molecule Highlighting< 1 %
Regex Extractor< 1 %- Form Encoded HTTP Entity Creator< 1 %
- Multipart Encoded HTTP Entity Creator< 1 %
- Window Slider< 1 %
- Customer Distributions< 1 %
- Message Slack User< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Random Numbers Generator< 1 %
- List Remote Files (legacy)< 1 %
Database Table Connector< 1 %Table Writer< 1 %- Fuzzy c-Means< 1 %
Scorer< 1 %- Tree Ensemble Learner< 1 %
- Cell Splitter< 1 %
- Cell Splitter By Position< 1 %
- Column Appender< 1 %
- Column Merger< 1 %
- Column to Grid< 1 %
- Cross Joiner< 1 %
- Edit Numeric Domain< 1 %
- String Splitter (Regex)< 1 %
- Number Rounder< 1 %
- Target Shuffling< 1 %
CASE Switch Model (Start)< 1 %- End IF< 1 %
- Extract Table Dimension< 1 %
- Timer Info< 1 %
ORC Writer< 1 %- Parallel Chunk End< 1 %
PostgreSQL Connector< 1 %- DB Reader< 1 %
- DB Query Injector< 1 %
- Counter Generation< 1 %
- Keras Network Executor< 1 %
- H2O Isolation Forest Learner< 1 %
Excel Reader (XLS)< 1 %Send to Power BI< 1 %- External SSH Tool< 1 %
- Java IF (Table)< 1 %
- Send to Tableau Server< 1 %
- t-SNE (L. Jonsson)< 1 %
- Column Filter Configuration< 1 %
- Date&Time Configuration< 1 %
- Value Selection Configuration< 1 %
- Text Output (legacy)< 1 %
- Credentials Input (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- File Chooser (legacy)< 1 %
- Single Selection (legacy)< 1 %
- JSON to Table< 1 %
- Labeling Filter< 1 %
MongoDB Reader< 1 %- Shortest Path< 1 %
- Object Inserter< 1 %
- Twitter Timeline< 1 %
- XML Row Combine and Write< 1 %
- RDKit Molecule Fragmenter< 1 %
- Conformal Classifier< 1 %
- Tautomer Generator< 1 %
Read PDB< 1 %- Residue Selector< 1 %
- XLS Sheet Selector< 1 %
- XLS Control Table from Cell Range< 1 %
- Input Files< 1 %
- SDF Writer< 1 %
- Correlation Pairs To Matrix< 1 %
- Message Slack channel< 1 %
IF Switch (Flow Variable Value)< 1 %- Generic Run-to-time Loop Start< 1 %
- Read Variables< 1 %
- Load Local Mol2 Files< 1 %
- Run Heavy Garbage Collector< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- MMP Molecule Multi-cut Fragment (RDKit)< 1 %
- Credential Variable Extractor< 1 %
PDB Connector< 1 %PDB Connector Custom Report< 1 %- PDB SMILES Query< 1 %
- PIA Analysis< 1 %
- Range Filter< 1 %
- Generic XML Reader< 1 %
- R Plot< 1 %
- MolImporter< 1 %
- Automated Matched Pairs< 1 %
- HTTP Connection (legacy)< 1 %
- String to URI< 1 %
- URI to String< 1 %
- Zip Files (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %- CSV Array Reader< 1 %
Database Connection Table Writer< 1 %Database Query< 1 %Database Row Filter< 1 %SQL Inject< 1 %Extract Context Properties< 1 %Simple File Reader< 1 %Line Reader< 1 %PMML Writer< 1 %Loop End (2 ports)< 1 %Interval Loop Start< 1 %Generic Loop Start< 1 %- X-Partitioner< 1 %
- Decision Tree Learner< 1 %
- Regression Predictor< 1 %
- PCA< 1 %
- Random Forest Predictor< 1 %
- Add Empty Rows< 1 %
- Bootstrap Sampling< 1 %
Cell Replacer< 1 %- Column Combiner< 1 %
- Column Comparator< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Column Aggregator< 1 %
- Lag Column< 1 %
- One to Many< 1 %
- Table Validator< 1 %
- Extract Missing Value Cause< 1 %
- Constant Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Joiner< 1 %
- Low Variance Filter< 1 %
- Pivot< 1 %
- Rank< 1 %
- Ungroup< 1 %
- Ruleset Editor< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Numeric Outliers< 1 %
- Proportion Test< 1 %
- Independent groups t-test< 1 %
- Cache< 1 %
- Data Generator< 1 %
- Interactive Pie chart (legacy)< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
- Spark DataFrame Java Snippet< 1 %
- Spark DataFrame Java Snippet (Source)< 1 %
- Spark SQL Query< 1 %
Vertica Connector< 1 %- Amazon Athena Connector< 1 %
- Amazon Authenticator< 1 %
- Azure Blob Store File Picker (legacy)< 1 %
- Parallel Chunk Start< 1 %
MySQL Connector< 1 %SQLite Connector< 1 %DB Loader< 1 %- DB Update< 1 %
- DB Pivot< 1 %
- Gaussian Distributed Assigner< 1 %
- Random Label Assigner< 1 %
- Time Series Generator< 1 %
- k-Medoids< 1 %
- Keras Network Writer< 1 %
- Keras Concatenate Layer< 1 %
- OpenBabel< 1 %
- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- External Tool< 1 %
- H2O Gradient Boosting Machine Learner (Regression)< 1 %
- H2O Predictor (Classification)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Bubble Chart (JFreeChart)< 1 %
Microsoft Authenticator (Deprecated)< 1 %- OSM Map to Image< 1 %
Excel Writer (XLS)< 1 %- Radar Plot Appender< 1 %
- Category to Class< 1 %
- Tika Parser URL Input< 1 %
- Flat File Document Parser< 1 %
- PubMed Document Parser< 1 %
- Dictionary Tagger< 1 %
- Strings to Document< 1 %
- Boolean Configuration< 1 %
- Double Configuration< 1 %
- Integer Slider Configuration< 1 %
- Column Selection Configuration< 1 %
- Value Selection (legacy)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Date&Time Widget< 1 %
- File Chooser Widget< 1 %
- File Upload Widget< 1 %
- File Download Widget< 1 %
- Image Output Widget (legacy)< 1 %
- JSON Row Combiner< 1 %
- Container Input (JSON)< 1 %
- Image Resizer< 1 %
- Labeling Arithmetic< 1 %
MongoDB Writer< 1 %- Partition Filter< 1 %
- Network Viewer< 1 %
- Multiobjective Subset Selection (NSGA-II)< 1 %
- Parameter Optimization Loop Start< 1 %
- Python Learner (legacy)< 1 %
- Python Predictor (legacy)< 1 %
Python Script (2⇒1)< 1 %Python Script (2⇒2)< 1 %- R Predictor< 1 %
- R Source (Workspace)< 1 %
- R to Table< 1 %
- R View (Table)< 1 %
R Model Writer< 1 %- Data to Report (BIRT)< 1 %
- PUT Request< 1 %
- Salesforce Simple Query< 1 %
- Salesforce SOQL< 1 %
- Test Data Generator< 1 %
- Date/Time Shift (legacy)< 1 %
- Twitter Post Tweet< 1 %
XGBoost Linear Ensemble Learner (Regression)< 1 %- XML Row Combiner< 1 %
- String to XML< 1 %
- RDKit Add Conformers< 1 %
- RDKit Generate Coords< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Molecule Substructure Filter< 1 %
- Neo4j Reader< 1 %
- Date Extractor< 1 %
Execute JavaScript< 1 %- Navigate< 1 %
- Synchronize< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- 0_install_AI_extensionsKNIME Hub
- 00_Visual_Analysis_of_Sales_Data(2)KNIME Forum
- 002_Variables - variable nodes 1KNIME Hub
- 004_Asset_Utilization_pigrecoKNIME Forum
- Show all 1284 workflows
Links
- KNIME Analytics Platform for Data Scientists (Advanced): Lesson 2. Flow Variables & Componentswww.knime.com/self-paced-course/l2-ds-knime-analytics-platform-for-data-scientists-advanced/lesson2
- Loading Error on AWS server - Missing node : table row to variableby MathieuSF on 2020-01-27forum.knime.com/p/79915
- Duplicate rows with a specific multiplierby qqilihq on 2020-02-17forum.knime.com/p/81739
- Send Email with two loops/variables?by armingrudd on 2020-03-04forum.knime.com/p/83318
- Parametrised database query - Using IN and LIKE clauses where the list of values is derived from an input fileby armingrudd on 2020-05-29forum.knime.com/p/92847
- Show all 11 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.