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 Predecessors
- JSON to Table5 %
Counting Loop Start4 %- R Snippet3 %
Numeric Scorer3 %CSV Writer2 %- Date&Time Difference2 %
- Multiple Selections (legacy)2 %
- URI to String2 %
Cell Splitter2 %Variable to Table Column2 %Binary Objects to Files1 %- Copy/Move Files (legacy)1 %
- List Box Input (legacy)1 %
- XPath1 %
- Add Empty Rows1 %
Table Column to Variable1 %- Container Input (Table)< 1 %
- Math Formula (Multi Column)< 1 %
- R Source (Table)< 1 %
- MarvinView< 1 %
Interval Loop Start< 1 %- Unzip Files (legacy)< 1 %
XLS Reader< 1 %- File Chooser Widget< 1 %
- String Manipulation< 1 %
- Excel Writer< 1 %
Variable Condition Loop End< 1 %- Ungroup< 1 %
- Split Collection Column< 1 %
Recursive Loop End< 1 %Cell Replacer< 1 %- String Splitter (Regex)< 1 %
- Java Snippet Row Filter< 1 %
- HiLite Row Splitter< 1 %
Line Reader< 1 %- GroupBy< 1 %
Merge Variables< 1 %- Molecule Type Cast< 1 %
Excel Reader (XLS)< 1 %- DB Query Reader< 1 %
- Load text-based files< 1 %
- Timer Info< 1 %
Read XLS Sheet Names< 1 %- R to Table< 1 %
- Multiple MolImporter< 1 %
- String to JSON< 1 %
Loop End (2 ports)< 1 %- Cache< 1 %
- Google Sheets Reader< 1 %
- Integer Input (legacy)< 1 %
Python Source< 1 %Table Row to Variable< 1 %SQL Extract< 1 %Concatenate (Optional in)< 1 %- Send Email< 1 %
Table to HTML String< 1 %- Create File Name (legacy)< 1 %
- JSON Schema Validator< 1 %
- Box Plot (legacy)< 1 %
- Date&Time to String< 1 %
- Modify Time Zone< 1 %
- External Tool< 1 %
Element Selector< 1 %- Binary Objects to Strings< 1 %
- Loop End (Column Append)< 1 %
- Linear Regression Learner< 1 %
- Column Name Extractor< 1 %
- Repository File Chooser Configuration< 1 %
- Table Creator< 1 %
- Perl Scripting< 1 %
- Column Combiner< 1 %
Double To Int< 1 %Row Filter (deprecated)< 1 %- Reference Row Splitter< 1 %
- Rank< 1 %
- Double Input (legacy)< 1 %
- Image Properties< 1 %
- Date&Time Shift< 1 %
- Time Difference (legacy)< 1 %
- RDKit Canon SMILES< 1 %
- Quit WebDriver< 1 %
Excel Sheet Appender (XLS)< 1 %- Date&Time Configuration< 1 %
- RDKit To Molecule< 1 %
IF Switch (Flow Variable Value)< 1 %- List Folders< 1 %
Linear Correlation< 1 %- Statistics< 1 %
CASE Switch Variable (Start)< 1 %- Random Number Assigner< 1 %
- H2O Numeric Scorer< 1 %
- Current URL< 1 %
- Upload (legacy)< 1 %
- URL to File Path< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
List Files< 1 %- X-Aggregator< 1 %
- Concatenate< 1 %
- Missing Value< 1 %
- Numeric Row Splitter< 1 %
- Data Generator< 1 %
- Similarity Search< 1 %
- OpenBabel< 1 %
- Math Formula< 1 %
- Math Formula (Variable)< 1 %
- Table View (JavaScript)< 1 %
- JSON Row Combiner< 1 %
- Parameter Optimization Loop End< 1 %
- Python Edit Variable (legacy)< 1 %
Extract Outer/InnerHTML< 1 %- Value Selection (legacy)< 1 %
- Excel Reader< 1 %
- String to Path< 1 %
- Benchmark End< 1 %
- Java Snippet< 1 %
- Chunk Loop Start< 1 %
Generic Loop Start< 1 %- Cross Joiner< 1 %
- Domain Calculator< 1 %
Column Rename< 1 %- Table Transposer< 1 %
- Rule Engine Variable< 1 %
- End IF< 1 %
- Weka Predictor (3.7)< 1 %
- String to Date&Time< 1 %
- Preset Date/Time (legacy)< 1 %
- HTTP Retriever< 1 %
PDB Connector< 1 %DB Loader< 1 %- Nominal Row Filter Widget< 1 %
- Scorer< 1 %
- Joiner< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Download (legacy)< 1 %
File Reader< 1 %- Group Loop Start< 1 %
- Constant Value Column< 1 %
- Table Validator (Reference)< 1 %
- Pivot< 1 %
- Sorter< 1 %
- Rule-based Row Filter< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- SDF Reader< 1 %
- Text Output (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Table to JSON< 1 %
XML Reader< 1 %- Port to URI< 1 %
- String to Number< 1 %
- Linear Correlation< 1 %
- CSV Reader< 1 %
- String to Path (Variable)< 1 %
- ARIMA Parameter Extractor< 1 %
- String to URI< 1 %
- Try (Variable Ports)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Extract Context Properties< 1 %- Column Aggregator< 1 %
Column Appender< 1 %- Column Resorter< 1 %
- Column Filter< 1 %
Row Splitter (deprecated)< 1 %Joiner< 1 %- Normalizer< 1 %
- Row Sampling< 1 %
- String Replacer< 1 %
- Value Counter< 1 %
- Rule Engine< 1 %
- Extract Table Spec< 1 %
- Conditional Box Plot (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Parallel Chunk Start< 1 %
- External SSH Tool< 1 %
- Java Snippet (simple)< 1 %
- Document Data Extractor< 1 %
- File Upload (legacy)< 1 %
- Column Selection (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Container Input (JSON)< 1 %
- Columns to JSON< 1 %
- Don't Save Start< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Modify Time< 1 %
Extract Attribute< 1 %- Wait< 1 %
- Load Text Files< 1 %
Table Column to Variable< 1 %- Image to Table< 1 %
- Numeric Scorer< 1 %
- Numeric Binner< 1 %
- String Configuration< 1 %
- Value Selection Configuration< 1 %
- Scorer (JavaScript)< 1 %
- Multiple Selection Widget< 1 %
- Container Output (Table)< 1 %
- Table Row to Variable< 1 %
- Column Appender< 1 %
- List Files/Folders< 1 %
- Recursive Loop End< 1 %
- Counting Loop Start< 1 %
- Generic Loop Start< 1 %
- Variable to Table Row< 1 %
- Chunk Loop Run-to-time Loop Start< 1 %
- Generic Run-for-time Loop Start< 1 %
- Download / Upload from List (legacy)< 1 %
- Extract URI Info< 1 %
Database Reader< 1 %Database SQL Executor< 1 %Database Writer< 1 %- X-Partitioner< 1 %
- Regression Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Column Rename (Regex)< 1 %
- Create Table Structure< 1 %
String To Number (PMML)< 1 %- Java IF (Table)< 1 %
- XML Row Combiner< 1 %
- RDKit Descriptor Calculation< 1 %
Click< 1 %- Start WebDriver< 1 %
- Read Variables< 1 %
- Benchmark Start< 1 %
- Download Files with Authentication< 1 %
- SVM Predictor< 1 %
- Constant Value Column Filter< 1 %
- Top k Row Filter< 1 %
- Spark to Table< 1 %
- RDKit Substructure Counter< 1 %
- Date&Time Part Extractor< 1 %
- Reaction Splitter< 1 %
Flow Variable End IF< 1 %- MolConverter< 1 %
- Audio Data Extractor< 1 %
- Active Branch Inverter< 1 %
CSV Reader< 1 %- Column List Loop Start< 1 %
- k-Means< 1 %
Number To String< 1 %- String to SVG< 1 %
- Double to Integer< 1 %
- Nominal Value Row Filter< 1 %
- Partitioning< 1 %
- RowID< 1 %
- Ruleset Editor< 1 %
- PMML to Cell< 1 %
- Column Expressions< 1 %
- Strings to Document< 1 %
- Column Filter (legacy)< 1 %
- Boolean Input (legacy)< 1 %
Container Input (Variable)< 1 %JSON Reader< 1 %Python Script (1⇒1)< 1 %- POST Request< 1 %
- PUT Request< 1 %
- Testflow Configuration< 1 %
- Time Generator (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
Database Delete< 1 %- Feature Selection Filter< 1 %
- Cell Splitter< 1 %
- Filter Apply< 1 %
H2O Binomial Scorer< 1 %Python Script (1⇒2)< 1 %- Multipart Encoded HTTP Entity Creator< 1 %
- Path to URI< 1 %
- Murcko Scaffold< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Naming< 1 %
- Delete Files (legacy)< 1 %
Table Row To Variable Loop Start< 1 %Model Writer< 1 %Recursive Loop End (2 ports)< 1 %- DBSCAN< 1 %
- Case Converter< 1 %
- Column Comparator< 1 %
String To Number< 1 %- Column Renamer (Dictionary)< 1 %
- Column to Grid< 1 %
- Correlation Filter< 1 %
- Equal Size Sampling< 1 %
- Extract Missing Value Cause< 1 %
- Reference Row Filter< 1 %
- Missing Value (Apply)< 1 %
- Number Rounder< 1 %
- Shuffle< 1 %
String Replace (Dictionary)< 1 %CASE Switch Data (Start)< 1 %MySQL Connector< 1 %- Empty Table Creator< 1 %
- TimeDelay Loop End< 1 %
- SAS7BDAT Reader< 1 %
- Java Edit Variable (simple)< 1 %
- Java Snippet Row Splitter< 1 %
- File Chooser (legacy)< 1 %
- XML to JSON< 1 %
Python Script (1⇒1)< 1 %Value Filter QuickForm (legacy)< 1 %Extract Date&Time Fields< 1 %- Twitter Users< 1 %
- RDKit MCS< 1 %
- RDKit Substructure Filter< 1 %
- URL Domain Extractor< 1 %
Table Extractor< 1 %- String to Table< 1 %
Variable to Table Row< 1 %- Feature Selection Loop End< 1 %
- Decision Tree Predictor< 1 %
- Category to Number< 1 %
Number To String (PMML)< 1 %- Independent groups t-test< 1 %
- Enrichment Plotter (legacy)< 1 %
- Save Workflow< 1 %
- DB Insert< 1 %
- DB Update< 1 %
- DB Writer< 1 %
- DB Query Extractor< 1 %
- TimeDelay Loop Start< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
Excel Reader (XLS)< 1 %Send to Tableau Server (Hyper)< 1 %- Unique Term Extractor< 1 %
- List Box Configuration< 1 %
Python Script (2⇒2)< 1 %- Molecule to CDK< 1 %
- RDKit From Molecule< 1 %
RMSE Calculator< 1 %- URL Extractor< 1 %
- URL Resolver< 1 %
- Form Encoded HTTP Entity Creator< 1 %
- Convert to Table< 1 %
- Interval Loop Start< 1 %
- Column Packer< 1 %
- Molecule Properties< 1 %
IF Switch (Flow Variable Value)< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Random Numbers Generator< 1 %
- FastQC_v2< 1 %
- MarvinSketch< 1 %
- Create Collection Column< 1 %
File Meta Info< 1 %- List Remote Files (legacy)< 1 %
- PNGs to Binary Objects< 1 %
- URL to File Path (Variable)< 1 %
- Breakpoint< 1 %
- Try (Data Ports)< 1 %
Variable to Table Row< 1 %Database Connection Table Reader< 1 %Database Update< 1 %Database Looping< 1 %- Extract System Properties< 1 %
Table Reader< 1 %Table Writer< 1 %- Java Edit Variable< 1 %
Loop End< 1 %Recursive Loop Start (2 ports)< 1 %Recursive Loop Start< 1 %Variable Loop End< 1 %- MultiLayerPerceptron Predictor< 1 %
Scorer< 1 %- Entropy Scorer< 1 %
- Random Forest Learner (Regression)< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Lag Column< 1 %
- Column Merger< 1 %
- Table Validator< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Reference Column Resorter< 1 %
- Column Splitter< 1 %
- String Manipulation (Variable)< 1 %
- Unpivot< 1 %
- Rule-based Row Splitter< 1 %
Rank Correlation< 1 %- Single sample t-test< 1 %
CASE Switch Data (End)< 1 %- Create Temp Dir (legacy)< 1 %
- Extract Table Dimension< 1 %
- Interactive Table (legacy)< 1 %
- Counter Generation< 1 %
Excel Reader (XLS)< 1 %Read Excel Sheet Names (XLS)< 1 %Excel Writer (XLS)< 1 %- Punctuation Erasure< 1 %
Strings To Document< 1 %- Term to String< 1 %
- Value Filter (legacy)< 1 %
- Credentials Input (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- JSON Path< 1 %
- JSON Transformer< 1 %
Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %- Python Source (legacy)< 1 %
- GET Request< 1 %
- Date&Time to legacy Date&Time< 1 %
- String to Duration< 1 %
- Modify Date< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Column to XML< 1 %
- HTML Parser< 1 %
- Alert< 1 %
Find Elements< 1 %Execute JavaScript< 1 %- Select< 1 %
- R-Group Decomposer< 1 %
- MCS Scaffold Finder< 1 %
- Cardinality< 1 %
- Total Count< 1 %
Flow Variable IF Switch< 1 %Loop End (3 ports)< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- Variable Timed Loop End< 1 %
- Collection to String< 1 %
- Collection Size< 1 %
- URL Encode< 1 %
- SnpSift< 1 %
- MolImporter< 1 %
- Desirability Ranking< 1 %
- XLS Enumerate Named Ranges< 1 %
- Create Directory (legacy)< 1 %
- File Meta Info (legacy)< 1 %
- Find MIME-Type< 1 %
- Strings to Binary Objects< 1 %
- Catch Errors (Var Ports)< 1 %
- Extract Variables (Data)< 1 %
Image Writer (Table Column)< 1 %- Read Images< 1 %
Gradient Boosted Trees Predictor< 1 %- Random Forest Predictor< 1 %
- Number to String< 1 %
- One to Many< 1 %
- Edit Numeric Domain< 1 %
- Duplicate Row Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Nominal Value Row Splitter< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
- Set Operator< 1 %
- Renderer to Image< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Shapiro-Wilk Test< 1 %
- HiLite Table (legacy)< 1 %
- Extract Color< 1 %
- DB Reader< 1 %
- DB Table Selector< 1 %
- One Row to Many< 1 %
- Random Boolean Assigner< 1 %
- Stresser< 1 %
- Time Series Generator< 1 %
- Model Loop Start< 1 %
- Boosting Learner Loop Start< 1 %
- Voting Loop End< 1 %
- Variable Expressions< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- Item Set Finder (Borgelt)< 1 %
- LIBSVMLearner< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Tika Language Detector< 1 %
- RegEx Filter< 1 %
- Flat File Document Parser< 1 %
- RSS Feed Reader< 1 %
- String to Term< 1 %
- t-SNE (L. Jonsson)< 1 %
- External Tool (Labs)< 1 %
- Nominal Row Filter Configuration< 1 %
- Local File Browser Configuration< 1 %
- Multiple Selection Configuration< 1 %
- Single Selection Configuration< 1 %
- CSS Editor< 1 %
- Image Output (legacy)< 1 %
Date Input (legacy)< 1 %- Single Selection (legacy)< 1 %
Column Filter Widget< 1 %- Interactive Value Filter Widget< 1 %
- Double Widget< 1 %
- List Box Widget< 1 %
- Container Input (Credentials)< 1 %
- Container Input (Row)< 1 %
- JSON to XML< 1 %
- PNG Image to ImgPlus< 1 %
- Image Normalizer< 1 %
- Inverter< 1 %
- Global Thresholder< 1 %
- Feature Calculator (BETA)< 1 %
- Binary Classification Inspector< 1 %
- Multiobjective Score Computation< 1 %
Python Script (2⇒1)< 1 %Integer Input (legacy)< 1 %List Box Input (legacy)< 1 %Column Filter QuickForm (legacy)< 1 %Multiple Selection Input QuickForm (legacy)< 1 %Value Selection QuickForm (legacy)< 1 %- Test Data Generator< 1 %
- Duration to String< 1 %
- Duration to Number< 1 %
- Date&Time-based Row Filter< 1 %
- XGBoost Predictor (Regression)< 1 %
- XML Column Combiner< 1 %
- Table to HTML String< 1 %
- StringCell To File< 1 %
- Row Splitter (col+)< 1 %
Binary Scorer< 1 %- Remove Empty Rows< 1 %
- RDKit Aromatizer< 1 %
- RDKit Kekulizer< 1 %
- RDKit To InChI< 1 %
Hash Calculator< 1 %- HTTP Result Data Extractor< 1 %
- Binary Objects to Files< 1 %
- Variable to Table Column< 1 %
- Line Reader< 1 %
- Variable Creator< 1 %
- Variable Loop End< 1 %
- Table Manipulator< 1 %
- String Manipulation (Multi Column)< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rank Correlation< 1 %
- Read Excel Sheet Names< 1 %
- SharePoint Online Connector< 1 %
- Path to String< 1 %
- Integer Configuration< 1 %
- Image Output Widget (legacy)< 1 %
- Python Script (legacy)< 1 %
- Hash Calculator< 1 %
Views
- This node has no views
Workflows
_01_ChemicalLibraryEnumerationKNIME Hub- _01_PMR_AnalysisKNIME Hub
- !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- 00_Download_DatasetKNIME Hub
- Show all 1220 workflows
Links
- KNIME E-Learning Course: Creation and usage of Flow Variables in a KNIME workflowwww.knime.com/knime-introductory-course/chapter7/section1/creation-and-usage-of-flow-variables
- KNIME E-Learning Course: Transforming a data cell into a flow variablewww.knime.com/knime-introductory-course/chapter7/section1/transforming-data-cell-into-flow-variable
- Loading Error on AWS server - Missing node : table row to variableby MathieuSF on 2020-01-27forum.knime.com/p/79915
- Automatically add date and time information to a data column with an exception of databy armingrudd on 2019-05-16forum.knime.com/p/60630
- copy a value up the number of rows of other columnsby armingrudd on 2019-01-13forum.knime.com/p/52713
- Show all 18 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.