Icon

15_​Conditional Filtering Solution

Part 1: Implement a workflow to separate data into groups A, B and C using Rule-based Row Filter nodes. Then apply a different method toeach group to calculate a variable called "NewCount":Group A: NewCount = Count * 2Group B: NewCount = 0Group C: NewCount = Count - AdjustmentFill in the blank nodes to acheive the desired result, and recombine into a single table using the Concatenate node. Part 2: Implement the same logic using a Column Expressions node, including a single if / else if / else statement. Part 1: Part 2: Input DataCode ACode BCode CCount * 2ZeroCount - AdjustmentRecombineresultsInput DataTable Creator Rule-basedRow Filter Rule-basedRow Filter Rule-basedRow Filter Math Formula Math Formula Math Formula Concatenate Column Expressions Table Creator Part 1: Implement a workflow to separate data into groups A, B and C using Rule-based Row Filter nodes. Then apply a different method toeach group to calculate a variable called "NewCount":Group A: NewCount = Count * 2Group B: NewCount = 0Group C: NewCount = Count - AdjustmentFill in the blank nodes to acheive the desired result, and recombine into a single table using the Concatenate node. Part 2: Implement the same logic using a Column Expressions node, including a single if / else if / else statement. Part 1: Part 2: Input DataCode ACode BCode CCount * 2ZeroCount - AdjustmentRecombineresultsInput DataTable Creator Rule-basedRow Filter Rule-basedRow Filter Rule-basedRow Filter Math Formula Math Formula Math Formula Concatenate Column Expressions Table Creator

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: ScottFincher
Created at: 2021-12-13
On NodePit since: 2021-12-19
Last update: 2024-04-27
Created with KNIME version: v4.5.0

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

Try NodePit Runner!