Table Row To Variable Run-for-time Loop Start

Loop start tablerow to variable node, which will run until a specified time period has elapsed. The user can specify the node behaviour in the event of missing values, and the time (dd:hh:mm:ss) at which the last iteration will start before. The loop will execute until that time is reached, when no further rows will be processed. If connected to a Run-to-time Loop end, the unprocessed rows will be available directly in the final port of the loop end node.

This node was developed by Vernalis Research . For feedback and more information, please contact knime@vernalis.com

Options

Missing Variable Values

Fail
Node execution will fail on encountering a missing value
Use defaults
Default values will be substituted on encountering a missing value
Skip (Add to unprocessed rows table)
Node execution will skip a row on encountering a missing value. The skipped row will be included in the 'unprocessed rows' table of a closing Timed Loop node.
Skip (Don't add to unprocessed rows table)
Node execution will skip a row on encountering a missing value.
Default Integer Value
The default value to be used for missing values in Integer columns
Default Double Value
The default value to be used for missing values in Double columns
Default String Value
The default value to be used for missing values in String columns

Expiry time

End time (dd:hh:mm:ss):
The time period after which execution will finish (dd:hh:mm:ss)
Start value of iteration counter
Allows the user to manually set the value at which the iteration counter will start (does not affect the processing of the table!)

Input Ports

Icon
Data table to process

Output Ports

Icon
The current variables

Popular Predecessors

Popular Successors

  • Twitter Search3 %
  • List Files2 %
  • ReadDbData2 %
  • Inject Variables (Data)2 %
  • Table Reader2 %
  • Rule Engine2 %
  • Excel Reader (XLS)2 %
  • ChEMBLdb Connector2 %
  • Create Date&Time Range1 %
  • Variable to Table Column1 %
  • k-Means1 %
  • Rule-based Row Filter1 %
  • Excel Writer1 %
  • Variable Timed Loop End1 %
  • Table Row to Variable1 %
  • String Manipulation (Variable)1 %
  • Rule Engine Variable1 %
  • DB Table Selector1 %
  • Read Excel Sheet Names1 %
  • JSON Reader1 %
  • Wait...< 1 %
  • Try (Variable Ports)< 1 %
  • Variable to Table Column< 1 %
  • Variable to Table Row< 1 %
  • Variable to Table Row< 1 %
  • CSV Reader< 1 %
  • File Reader< 1 %
  • File Reader (deprecated)< 1 %
  • Java Snippet< 1 %
  • Counting Loop Start< 1 %
  • Chunk Loop Start< 1 %
  • Variable Condition Loop End< 1 %
  • Variable Loop End< 1 %
  • Variable Loop End< 1 %
  • Constant Value Column< 1 %
  • Column Filter< 1 %
  • Row Filter< 1 %
  • Rule-based Row Splitter< 1 %
  • Merge Variables< 1 %
  • Send Email< 1 %
  • DB Query Reader< 1 %
  • Column Expressions< 1 %
  • Variable Expressions< 1 %
  • Math Formula (Variable)< 1 %
  • XLS Reader< 1 %
  • Excel Reader< 1 %
  • Create File/Folder Variables< 1 %
  • List Files/Folders< 1 %
  • String to Path (Variable)< 1 %
  • Google Authentication< 1 %
  • Parameter Optimization Loop End< 1 %
  • Python Source< 1 %
  • XML Reader< 1 %
  • Bash< 1 %
  • European PubMed Central Advanced Search< 1 %
  • JevisGetData< 1 %
  • Java Edit Variable< 1 %
  • Linear Regression Learner< 1 %
  • String Manipulation< 1 %
  • Merge Variables< 1 %
  • SDF Reader< 1 %
  • Python Edit Variable< 1 %
  • Variable to Table Row< 1 %
  • Database Reader (legacy)< 1 %
  • Database Writer< 1 %
  • Line Reader< 1 %
  • Table Creator< 1 %
  • Decision Tree Learner< 1 %
  • Nominal Value Row Splitter< 1 %
  • Row Splitter< 1 %
  • GroupBy< 1 %
  • IF Switch< 1 %
  • Amazon S3 File Picker< 1 %
  • DB Connector< 1 %
  • DB SQL Executor< 1 %
  • DB Row Filter< 1 %
  • Excel Reader (XLS) (deprecated)< 1 %
  • RDKit R-Group Decomposition (deprecated)< 1 %
  • Flow Variable End IF< 1 %
  • ARIMA Learner< 1 %
  • Copy/Move Files< 1 %
  • Database Table Connector< 1 %
  • CSV Writer< 1 %
  • Cluster Assigner< 1 %
  • K Nearest Neighbor< 1 %
  • RProp MLP Learner< 1 %
  • Random Forest Learner (Regression)< 1 %
  • Numeric Row Splitter< 1 %
  • Shuffle< 1 %
  • Color Manager< 1 %
  • Interactive Table< 1 %
  • Generic Web Service Client< 1 %
  • Read Excel Sheet Names (XLS)< 1 %
  • Excel Writer (XLS)< 1 %
  • Multiple Selection Configuration< 1 %
  • JSON Input< 1 %
  • Python Edit Variable< 1 %
  • Salesforce Simple Query< 1 %
  • Twitter Followers Search< 1 %
  • Twitter Timeline< 1 %
  • XPath< 1 %
  • RDKit Substructure Filter< 1 %
  • Read from Shapefile< 1 %
  • SDF Concatenate< 1 %
  • Clean HTML Retriever< 1 %
  • IF Switch (Flow Variable Value)< 1 %
  • Flow Variable IF Switch< 1 %
  • Flow Variable IF Switch (Flow Variable Value)< 1 %
  • Loop End (3 ports)< 1 %
  • Table Row To Variable Run-to-time Loop Start< 1 %
  • Load SD-Files (SDF)< 1 %
  • URL Encode< 1 %
  • Load Layout< 1 %
  • Generic XML Reader< 1 %
  • MolConverter< 1 %
  • Binary Objects to Strings< 1 %
  • Download< 1 %
  • List Remote Files< 1 %
  • Unzip Files< 1 %
  • Variable to Table Column< 1 %
  • Create File Name< 1 %
  • Inject Variables (Database)< 1 %
  • Table Row to Variable< 1 %
  • Table Row To Variable Loop Start< 1 %
  • Image Writer (Port)< 1 %
  • CSV Reader (deprecated)< 1 %
  • CSV Writer< 1 %
  • Database Table Selector< 1 %
  • Database Connector< 1 %
  • Extract Context Properties< 1 %
  • Line Reader< 1 %
  • Variable Creator< 1 %
  • Feature Selection Filter< 1 %
  • Feature Selection Loop End< 1 %
  • Loop End< 1 %
  • Loop End (Column Append)< 1 %
  • Loop End< 1 %
  • Generic Loop Start< 1 %
  • Group Loop Start< 1 %
  • Table Row To Variable Loop Start< 1 %
  • X-Partitioner< 1 %
  • K Nearest Neighbor< 1 %
  • SVM Learner< 1 %
  • Gradient Boosted Trees Learner (Regression)< 1 %
  • Cell Splitter< 1 %
  • Column Comparator< 1 %
  • Number To String< 1 %
  • Column Appender< 1 %
  • Column Rename (Regex)< 1 %
  • Reference Row Filter< 1 %
  • Joiner< 1 %
  • Column Rename< 1 %
  • Sorter< 1 %
  • String Replacer< 1 %
  • Transpose< 1 %
  • CASE Switch Data (Start)< 1 %
  • Create Temp Dir (legacy)< 1 %
  • Timer Info< 1 %
  • Crosstab< 1 %
  • PySpark Script (1 to 1)< 1 %
  • MySQL Connector< 1 %
  • DB Reader< 1 %
  • DB Query< 1 %
  • DB Table Creator (Labs)< 1 %
  • TimeDelay Loop End< 1 %
  • Call Local Workflow (Row Based)< 1 %
  • H2O Predictor (Regression)< 1 %
  • Math Formula< 1 %
  • Math Formula (Multi Column)< 1 %
  • LIBSVMLearner< 1 %
  • Microsoft Authentication< 1 %
  • Excel Reader (XLS)< 1 %
  • Excel Sheet Appender (XLS)< 1 %
  • Java Edit Variable (simple)< 1 %
  • Document Grabber< 1 %
  • PDF Parser< 1 %
  • RandomForest (3.7)< 1 %
  • Path to String (Variable)< 1 %
  • Transfer Files< 1 %
  • Date&Time Input< 1 %
  • String Input< 1 %
  • Single Selection< 1 %
  • Parameter Optimization Loop Start< 1 %
  • Python Script (1⇒1)< 1 %
  • R Source (Table)< 1 %
  • R to Table< 1 %
  • GET Request< 1 %
  • POST Request< 1 %
  • Webpage Retriever< 1 %
  • Date/Time Shift< 1 %
  • String to Date/Time< 1 %
  • Twitter API Connector< 1 %
  • Twitter Streaming< 1 %
  • Twitter Post Tweet< 1 %
  • XML Reader< 1 %
  • XML Writer< 1 %
  • RDKit Canon SMILES< 1 %
  • RDKit One Component Reaction< 1 %
  • Google Address Geocoder< 1 %
  • HTTP Retriever< 1 %
  • HTML Parser< 1 %
  • WebDriver Factory< 1 %
  • WebDriver Factory< 1 %
  • Find Elements< 1 %
  • Navigate< 1 %
  • Send Keys< 1 %
  • Start WebDriver< 1 %

Views

This node has no views

Workflows

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.