0 ×

Table Row To Variable Run-to-time Loop Start

Vernalis PDB extension for KNIME Workbench version 1.17.3.v201808160901 by Vernalis (R&D), UK

Loop start tablerow to variable node, which will run until a specified time of day has passed. The user can specify the node behaviour in the event of missing values, and the time (hh:mm) 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 (hh:mm):
The time at which execution will finish (hh : mm)
Run to tomorrow
If the expiry time has already passed today at the time of loop execution commencement it will run until that time tomorrow
Run through weekend
If the expiry time (accounting for the 'Run to tomorrow' setting) is on a Saturday or Sunday, then the loop will run until that time on the following Monday
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

Input table to process

Output Ports

The current variables

Best Friends (Incoming)

Best Friends (Outgoing)

Update Site

To use this node in KNIME, install Vernalis PDB extension for KNIME Workbench from the following update site:

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.