Table Row To Variable Run-for-time Loop Start
Vernalis Flow Control extension for KNIME Workbench version 1.26.0.v202003171242 by Vernalis (R&D), UK
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
Output Ports
Best Friends (Incoming)
- List Files (14 %)
- Table Creator (6 %)
- GroupBy (6 %)
Table Row to Variable(4 %) Deprecated- File Reader (4 %) Streamable
- Constant Value Column (4 %) Streamable
- Column Filter (4 %) Streamable
- Rule-based Row Filter (4 %) Streamable
XLS Reader(4 %) Deprecated- Derive Fields (2 %)
- MarvinSketch (2 %)
- Wait... (2 %)
- Table Row To Variable Loop Start (2 %)
Variable to Table Row(2 %) Deprecated- CSV Reader (2 %)
- Database Connection Table Reader (legacy) (2 %)
- Database Reader (legacy) (2 %)
- Database Writer (legacy) (2 %) Streamable
- Table Reader (2 %) Streamable
- Loop End (2 %)
- Chunk Loop Start (2 %)
- Extract Column Header (2 %)
- Domain Calculator (2 %)
- Row Filter (2 %) Streamable
- Regex Split (2 %) Streamable
- Column Rename (2 %) Streamable
- RowID (2 %) Streamable
- Sorter (2 %)
- String Manipulation (2 %) Streamable
- Transpose (2 %)
- Rule Engine (2 %) Streamable
- Math Formula (2 %) Streamable
Excel Reader (XLS)(2 %) StreamableDeprecated- Parameter Optimization Loop End (2 %)
- Show all 34 recommendations
Best Friends (Outgoing)
- Row Filter (12 %) Streamable
- CSV Reader (6 %)
- Database Reader (legacy) (4 %)
- SDF Reader (4 %)
- ReadDbData (3 %)
- Rule Engine (3 %) Streamable
- Send Email (3 %)
- Amazon S3 File Picker (3 %)
Excel Reader (XLS)(3 %) StreamableDeprecated- ChEMBLdb Connector (3 %)
- Variable Timed Loop End (1 %)
- European PubMed Central Advanced Search (1 %) Streamable
- JevisGetData (1 %)
- ARIMA Learner (1 %)
Variable to Table Column(1 %) StreamableDeprecated- Inject Variables (Data) (1 %)
Table Row to Variable(1 %) DeprecatedVariable to Table Row(1 %) Deprecated- Database Connector (legacy) (1 %)
- File Reader (1 %) Streamable
Line Reader(1 %) Deprecated- List Files (1 %)
- Counting Loop Start (1 %)
- Chunk Loop Start (1 %)
- Variable Condition Loop End (1 %)
- Variable Loop End (1 %)
- k-Means (1 %)
- Decision Tree Learner (1 %)
Number To String(1 %) Deprecated- Column Appender (1 %) Streamable
- Column Rename (Regex) (1 %) Streamable
- Constant Value Column (1 %) Streamable
- Column Filter (1 %) Streamable
- Reference Row Filter (1 %)
- String Manipulation (1 %) Streamable
- Rule-based Row Filter (1 %) Streamable
- Merge Variables (1 %)
- Interactive Table (local) (1 %)
- TimeDelay Loop End (1 %)
- Math Formula (1 %) Streamable
Excel Reader (XLS)(1 %) StreamableDeprecatedExcel Sheet Appender (XLS)(1 %) Deprecated- MultilayerPerceptron (3.7) (1 %)
- Container Input (JSON) (1 %)
- Parameter Optimization Loop Start (1 %)
Python Edit Variable(1 %) Deprecated- String to Date/Time (legacy) (1 %) Streamable
- Twitter Search (1 %) Streamable
- Show all 48 recommendations
Installation
To use this node in KNIME, install Vernalis KNIME Nodes from the following update site:
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.