0 ×

CASE Switch Variable (Start)

KNIME Base Nodes version 4.1.0.v201912041211 by KNIME AG, Zurich, Switzerland

This nodes takes the flow variables from the input port and moves it to exactly one active output branch.

NOTE - Due to the way in which flow variables are handled within KNIME, the flow variable values for any existing flow variables beyond the corresponding "end" node will always be those at the top-most port of the "end" node. New variables created in any active branch will retain their correct values. If you need to change the value of existing variables, please either use a new flow variable, or use a Variable to Table Row node before a conventional End CASE node.

This node is derived from the Vernalis community extension.

Options

Select active port: Select the active output port
Activate all outputs during configuration step: When set the node will keep all outputs active during workflow configuration (that is, while the traffic light of the node is 'yellow'). This allows the configuration of connected downstream nodes and simplifies the workflow design at the expense of additional configuration calls of nodes that are later on inactive. It's recommended to switch this flag off for production workflows as this avoids unnecessary configuration calls of the inactive branches.

Input Ports

: Flow Variable input port

Output Ports

: First flow variable output port
: Second flow variable output port
: Third flow variable output port

Best Friends (Incoming)

Rule Engine Variable (16 %)
~~Table Row to Variable~~ (12 %) Deprecated
Java Edit Variable (7 %)
~~Table Column to Variable~~ (6 %) Deprecated
Single Selection (4 %)
Python Edit Variable (4 %)
Table Row To Variable Loop Start (3 %)
Math Formula (Variable) (3 %)
Boolean Input (3 %)
String Manipulation (Variable) (2 %)
Merge Variables (2 %)
Java Edit Variable (simple) (2 %)
Date&Time Input (2 %)
String Input (2 %)
Database SQL Executor (legacy) (2 %)
CASE Switch Variable (Start) (2 %)
Empty Table Switch (2 %)
Integer Input (2 %)
Wait... (1 %)
Extract Variables (Data) (1 %)
GroupBy (1 %)
Value Selection (1 %)
R Snippet (1 %)
XLS Named Range Reader (< 1 %)
Catch Errors (Data Ports) (< 1 %)
Catch Errors (Var Ports) (< 1 %)
Create File Name (< 1 %)
Database Writer (legacy) (< 1 %) Streamable
List Files (< 1 %)
Java Snippet (< 1 %) Streamable
Counting Loop Start (< 1 %)
Variable Loop End (< 1 %)
Concatenate (< 1 %) Streamable
Rule-based Row Filter (< 1 %) Streamable
CASE Switch Variable (End) (< 1 %)
CASE Switch Data (End) (< 1 %)
Cache (< 1 %)
Extract Table Dimension (< 1 %)
Empty Table Creator (< 1 %)
~~Excel Writer (XLS)~~ (< 1 %) Deprecated
Double Input (< 1 %)
Generic JavaScript View (< 1 %)
JSON to Table (< 1 %)
Parameter Optimization Loop End (< 1 %)
~~Python Edit Variable~~ (< 1 %) Deprecated
Python Script (1⇒1) (< 1 %)
R Source (Workspace) (< 1 %)
R To R (< 1 %)
R to Table (< 1 %)
String to Date/Time (legacy) (< 1 %) Streamable
Show all 50 recommendations

Best Friends (Outgoing)

CASE Switch Variable (End) (9 %)
Database Reader (legacy) (5 %)
String Manipulation (Variable) (5 %)
Table Creator (3 %)
~~Variable to Table Row~~ (2 %) Deprecated
CSV Reader (2 %)
Database SQL Executor (legacy) (2 %)
Java Edit Variable (2 %)
Merge Variables (2 %)
Text Output (2 %)
Date&Time Input (2 %)
AQM Connector (1 %)
Column Filter (1 %) Streamable
Row Filter (1 %) Streamable
GroupBy (1 %)
CASE Switch Variable (Start) (1 %)
Send Email (1 %)
WrappedNode Output (1 %)
~~Excel Reader (XLS)~~ (1 %) StreamableDeprecated
~~Variable to Table Column~~ (< 1 %) StreamableDeprecated
~~Table Row to Variable~~ (< 1 %) Deprecated
Database Connector (legacy) (< 1 %)
Database Drop Table (legacy) (< 1 %)
File Reader (< 1 %) Streamable
Table Reader (< 1 %) Streamable
Constant Value Column (< 1 %) Streamable
Math Formula (< 1 %) Streamable
Math Formula (Variable) (< 1 %)
Java Edit Variable (simple) (< 1 %)
Generic JavaScript View (< 1 %)
R Snippet (< 1 %)
Fail in execution (< 1 %) Streamable
GET Resource (< 1 %)
Percentile (< 1 %)
ZipLoopStart (< 1 %)
Hive Connector (< 1 %)
Random Numbers Generator (< 1 %) Streamable
Sphere Exclusion (< 1 %)
Breakpoint (< 1 %)
Wait... (< 1 %)
Catch Errors (Data Ports) (< 1 %)
Catch Errors (Var Ports) (< 1 %)
Try (Variable Ports) (< 1 %)
Active Branch Inverter (< 1 %)
Create File Name (< 1 %)
Table Row To Variable Loop Start (< 1 %)
CSV Writer (< 1 %) Streamable
Database Update (legacy) (< 1 %)
Database Writer (legacy) (< 1 %) Streamable
Database Looping (legacy) (< 1 %)
Database Table Selector (legacy) (< 1 %)
List Files (< 1 %)
Java Snippet (< 1 %) Streamable
Loop End (< 1 %)
Variable Condition Loop End (< 1 %)
Generic Loop Start (< 1 %)
Variable Loop End (< 1 %)
Decision Tree Learner (< 1 %)
Concatenate (< 1 %) Streamable
Extract Column Header (< 1 %)
Column Resorter (< 1 %) Streamable
Row Splitter (< 1 %) Streamable
Joiner (< 1 %)
Partitioning (< 1 %)
Pivoting (< 1 %)
Missing Value (< 1 %)
Rank (< 1 %)
Column Rename (< 1 %) Streamable
RowID (< 1 %) Streamable
Sorter (< 1 %)
Column Splitter (< 1 %) Streamable
String Manipulation (< 1 %) Streamable
Transpose (< 1 %)
Rule-based Row Filter (< 1 %) Streamable
Rule Engine (< 1 %) Streamable
Rule Engine Variable (< 1 %)
CASE Switch Data (End) (< 1 %)
End IF (< 1 %)
IF Switch (< 1 %)
CASE Switch Data (Start) (< 1 %)
Extract Table Dimension (< 1 %)
Data Generator (< 1 %) Streamable
Spark DataFrame Java Snippet (Source) (< 1 %)
Vertica Connector (legacy) (< 1 %)
MySQL Connector (legacy) (< 1 %)
SQLite Connector (legacy) (< 1 %)
Empty Table Creator (< 1 %)
Cell To PMML (< 1 %)
Column Expressions (< 1 %) Streamable
Table to PDF (< 1 %)
~~XLS Reader~~ (< 1 %) Deprecated
~~XLS Sheet Appender~~ (< 1 %) Deprecated
~~Excel Reader (XLS)~~ (< 1 %) StreamableDeprecated
Column Filter (< 1 %)
Boolean Input (< 1 %)
Double Input (< 1 %)
File Chooser (< 1 %)
String Input (< 1 %)
Single Selection (< 1 %)
Scatter Plot (< 1 %)
Table to JSON (< 1 %)
MongoDB Reader (< 1 %)
Parameter Optimization Loop Start (< 1 %)
Python Script (1⇒1) (< 1 %)
Python Edit Variable (< 1 %)
R To R (< 1 %)
GET Request (< 1 %) Streamable
Date/Time Shift (legacy) (< 1 %)
Moving Aggregation (< 1 %)
XPath (< 1 %) Streamable
Table to HTML String (< 1 %) Streamable
Show all 111 recommendations

Workflows

Installation

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

KNIME 4.1

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.

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.