0 ×

Database IF Switch (Flow Variable Value)

DeprecatedVernalis Flow Control extension for KNIME Workbench version 1.27.2.v202010191232 by Vernalis (R&D), UK

This node provides an IF switch which selects the active database connection port based on the comparison of a flow variable with a user-entered value. The comparison method can also be selected. It can be considered to be broadly similar in function to the Java Snippet IF Switch node in the core KNIME implementation.

WARNING: This deprecated version performs reverse lexicographical comparisons for string variables

If numeric variables (double or integer types) are selected, the node will attempt to process the user-entered value as a number. If this cannot be done, then the node will not be executable. An empty string will not be interpreted as a numeric value. Note that integers can not be compared with values where a '.' is present, so '1.0' cannot be interpreted, but '1' can.

For doubles, a threshold is specified in the dialogue. If the variable is within this threshold of the comparison value it will be considered to be equal to it (Applies to =, !=, >= and <= comparisons).

String comparisons are ' lexicographical ' - i.e. the sorting order mirrors that in which the strings would be expected to appear in a dictionary.

If the comparison is considered to be 'true', then the top port will be active, otherwise the bottom port will be active

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

Options

Flow variable selection (un-named in dialogue)
Select from the available flow variables
Comparison operator selection (un-named in dialogue)
Select the required comparison operation
Comparison value (un-named in dialogue)
Enter a value
Ignore case
Ignore the case (String comparisons only)
Ignore leading/trailing whitespace
Ignore leading / trailing white-space characters (String comparisons only)
Equality tolerance
The maximum difference between double values within which they will still be considered to be equal

Input Ports

Icon
Database connection port containing flow variable with value to compare

Output Ports

Icon
Active port if comparison is true
Icon
Active port if comparison is false

Best Friends (Incoming)

Best Friends (Outgoing)

Installation

To use this node in KNIME, install Vernalis KNIME Nodes from the following update site:

KNIME 4.2

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.