Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Database IF Switch (Flow Variable Value) (deprecated)
NodeNode / Manipulator

Database IF Switch (Flow Variable Value) (deprecated)

Uncategorized

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

Like
Copy short link

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.

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

Node details

Input ports
  1. Type: Database Query
    Input port
    Database connection port containing flow variable with value to compare
Output ports
  1. Type: Database Query
    true
    Active port if comparison is true
  2. Type: Database Query
    false
    Active port if comparison is false

Extension

The Database IF Switch (Flow Variable Value) (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

    1. Go to item

    KNIME
    Open for Innovation

    KNIME AG
    Talacker 50
    8001 Zurich, Switzerland
    • Software
    • Getting started
    • Documentation
    • E-Learning course
    • Solutions
    • KNIME Hub
    • KNIME Forum
    • Blog
    • Events
    • Partner
    • Developers
    • KNIME Home
    • KNIME Open Source Story
    • Careers
    • Contact us
    Download KNIME Analytics Platform Read more on KNIME Business Hub
    © 2023 KNIME AG. All rights reserved.
    • Trademarks
    • Imprint
    • Privacy
    • Terms & Conditions
    • Credits