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 AB_NYC_2019dataAvg price by room type and neighborhood groupAvg price bynumber of reviews andneighborhood groupBin num of reviewsinto 3 categoriescategorycategoryShow average pricesShow average prices CSV Reader Pivoting Pivoting Numeric Binner Column Rename Column Rename Bar Chart Bar Chart 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 AB_NYC_2019dataAvg price by room type and neighborhood groupAvg price bynumber of reviews andneighborhood groupBin num of reviewsinto 3 categoriescategorycategoryShow average pricesShow average prices CSV Reader Pivoting Pivoting Numeric Binner Column Rename Column Rename Bar Chart Bar Chart

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-12
Last update: 2024-04-27
Created with KNIME version: v4.5.0
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!