Icon

kn_​forum_​45444_​segmentation_​split_​percent_​rank

create a rank / percent in three thresholds with the help of Counter node

create a rank / percent in three thresholds with the help of Counter node

create a rank / percent in three thresholds with the help of Counter node if(column("NGR") >= variable("high_threshold")) {"high"} else if (column("NGR") >= variable("mid_threshold")) {"mid"} else {"low"} KNIME_test.xlsxsort by NGRascendingfor RankMaximum Counterpct_countertransform the ranksto PercentsMaximum CounterdefinethresholdshighlowmidhighlowmidhighMinimum of high NGRhigh_thresholdlowMinimum of high NGRlow_thresholdNode 21high_thresholdlow_thresholdMinimum of high NGRmid_thresholdmidmid_thresholdNode 28 Excel Reader Sorter Counter Generation GroupBy Math Formula Table Rowto Variable Table Creator Row Filter Row Filter Row Filter Table Rowto Variable Table Rowto Variable Table Rowto Variable Rule-basedRow Filter GroupBy Column Rename Rule-basedRow Filter GroupBy Column Rename Column Expressions Table Rowto Variable Table Rowto Variable GroupBy Column Rename Rule-basedRow Filter Table Rowto Variable Merge Variables create a rank / percent in three thresholds with the help of Counter node if(column("NGR") >= variable("high_threshold")) {"high"} else if (column("NGR") >= variable("mid_threshold")) {"mid"} else {"low"} KNIME_test.xlsxsort by NGRascendingfor RankMaximum Counterpct_countertransform the ranksto PercentsMaximum CounterdefinethresholdshighlowmidhighlowmidhighMinimum of high NGRhigh_thresholdlowMinimum of high NGRlow_thresholdNode 21high_thresholdlow_thresholdMinimum of high NGRmid_thresholdmidmid_thresholdNode 28Excel Reader Sorter Counter Generation GroupBy Math Formula Table Rowto Variable Table Creator Row Filter Row Filter Row Filter Table Rowto Variable Table Rowto Variable Table Rowto Variable Rule-basedRow Filter GroupBy Column Rename Rule-basedRow Filter GroupBy Column Rename Column Expressions Table Rowto Variable Table Rowto Variable GroupBy Column Rename Rule-basedRow Filter Table Rowto Variable Merge Variables

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: m_lauber
Created at: 2022-08-03
On NodePit since: 2022-08-03
Last update: 2024-04-27
Created with KNIME version: v4.6.1
Tags: rankcounterpercent

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

Try NodePit Runner!