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

  • Excel Reader5 %
  • List Files4 %
  • Read Excel Sheet Names (XLS)3 %
  • Rule-based Row Filter3 %
  • Table Row to Variable2 %
  • Table Creator2 %
  • Column Filter2 %
  • Column Rename2 %
  • String Manipulation2 %
  • Chunk Loop Run-for-time Loop Start2 %
  • URL to File Path2 %
  • Excel Reader (XLS)2 %
  • ROC Curve2 %
  • CSV Reader2 %
  • Column Aggregator2 %
  • File Reader2 %
  • Chunk Loop Start2 %
  • Row Filter2 %
  • GroupBy2 %
  • Column List Loop Start2 %
  • Column Splitter2 %
  • String Replacer2 %
  • Excel Reader (XLS)2 %
  • Read Excel Sheet Names2 %
  • List Files/Folders2 %
  • Table Row to Variable2 %
  • Duplicate Row Filter2 %
  • Group Loop Start2 %
  • DB Query Reader2 %
  • Table Row To Variable Loop Start1 %
  • Sorter1 %
  • Transpose1 %
  • Value Counter1 %
  • CSV Reader1 %
  • XLS Reader1 %
  • Rule-based Row Splitter1 %
  • XPath1 %
  • Reference Row Filter1 %
  • Database Reader< 1 %
  • Constant Value Column< 1 %
  • Regex Split< 1 %
  • RowID< 1 %
  • Parameter Optimization Loop End< 1 %
  • List Folders< 1 %
  • JevisSelectData< 1 %
  • Variable to Table Column< 1 %
  • Variable to Table Column< 1 %
  • SDF Reader< 1 %
  • Generic Loop Start< 1 %
  • Auto-Binner< 1 %
  • Table Editor< 1 %
  • Derive Fields< 1 %
  • MarvinSketch< 1 %
  • Wait...< 1 %
  • Variable to Table Row< 1 %
  • Database Connection Table Reader< 1 %
  • Database Writer< 1 %
  • Table Reader< 1 %
  • Loop End< 1 %
  • Extract Column Header< 1 %
  • Domain Calculator< 1 %
  • Rule Engine< 1 %
  • Math Formula< 1 %
  • Excel Reader (XLS)< 1 %
  • Timed Loop End (1 port)< 1 %
  • Variable Timed Loop End< 1 %
  • Download< 1 %
  • List Remote Files< 1 %
  • String to URI< 1 %
  • Unzip Files< 1 %
  • Table Column to Variable< 1 %
  • Java Snippet< 1 %
  • Recursive Loop Start< 1 %
  • Column Combiner< 1 %
  • String To Number< 1 %
  • Double To Int< 1 %
  • Row Splitter< 1 %
  • Reference Row Splitter< 1 %
  • Joiner< 1 %
  • Unpivoting< 1 %
  • Extract Table Dimension< 1 %
  • Parallel Chunk Start< 1 %
  • Empty Table Creator< 1 %
  • TimeDelay Loop Start< 1 %
  • Multiple Selections< 1 %
  • Date&Time-based Row Filter< 1 %
  • Time Generator< 1 %
  • Row Splitter (col+)< 1 %
  • List To Set< 1 %
  • Random Numbers Generator< 1 %
  • Counting Loop Start< 1 %
  • X-Aggregator< 1 %
  • Concatenate< 1 %
  • Cross Joiner< 1 %
  • String Manipulation (Multi Column)< 1 %
  • Counter Generation< 1 %
  • Path to String< 1 %
  • String to Path< 1 %
  • Transfer Files< 1 %
  • Transfer Files (Table)< 1 %
  • String to Date/Time (legacy)< 1 %

Popular Successors

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.