Icon

06 Switches

06 Switches
Exercise: IF SwitchBelow you see two workflow branches that calculate and visualize theprices by neighborhood and a second category, which is either the roomtype or number of reviews. Create an IF switch that builds one of thesevisualizations based on a user selection.1.1) Separate the workflow branches after the CSV Reader node with an IFSwitch node1.2) Collect the data from the active branch with the End IF node, andconnect it to the top Bar Chart node. You can delete the bottom Bar Chartnode.1.3) Create a Single Selection Configuration node with two selectionoptions: "room type" and "number of reviews"1.4) Encode the flow variable into "top" if room type was selected, and into"bottom" otherwise. Overwrite the active port setting of the IF Switch nodewith this flow variable.1.5) Encapsulate the nodes into a component. Configure the componentand open its interactive view. Which neighborhood group is the mostexpensive for all room types? Read ITHelpDesk.csvAvg days open and ticket typeAvg satisfaction byrequestor and priorityBin num of reviewsinto 3 categoriescategorycategoryShow average typeShow average typeRead ITHelpDesk.csv CSV Reader Pivoting Pivoting Numeric Binner Column Rename Column Rename Bar Chart Bar Chart CSV Reader Visualize prices by neighborhoodand selected category Exercise: IF SwitchBelow you see two workflow branches that calculate and visualize theprices by neighborhood and a second category, which is either the roomtype or number of reviews. Create an IF switch that builds one of thesevisualizations based on a user selection.1.1) Separate the workflow branches after the CSV Reader node with an IFSwitch node1.2) Collect the data from the active branch with the End IF node, andconnect it to the top Bar Chart node. You can delete the bottom Bar Chartnode.1.3) Create a Single Selection Configuration node with two selectionoptions: "room type" and "number of reviews"1.4) Encode the flow variable into "top" if room type was selected, and into"bottom" otherwise. Overwrite the active port setting of the IF Switch nodewith this flow variable.1.5) Encapsulate the nodes into a component. Configure the componentand open its interactive view. Which neighborhood group is the mostexpensive for all room types? Read ITHelpDesk.csvAvg days open and ticket typeAvg satisfaction byrequestor and priorityBin num of reviewsinto 3 categoriescategorycategoryShow average typeShow average typeRead ITHelpDesk.csv CSV Reader Pivoting Pivoting Numeric Binner Column Rename Column Rename Bar Chart Bar Chart CSV Reader Visualize prices by neighborhoodand selected category

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2020-10-27
On NodePit since: 2022-03-11
Last update: 2024-11-18
Created with KNIME version: v4.5.1
Tags: switchend IF

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!