Icon

20211027_​count_​higher_​than_​loopgroup_​v3

@elsamuel 's solution: https://hub.knime.com/elsamuel/spaces/Public/latest/rsierrama%20-%20Count%20Values%20above%20threshold~oJyivGFe34DQGJhV: Outputs: Data to LONG format$ColumnValues$ > 5 => 1GroupBy IDAggreagate query using SumMid-Lower boundmean-sdLoop12 stepsSELECT 'Qn [Binned]'Count Qn [Binned]Add Qn [Binned].CountcolumnCollectDataSort by Qn Column*Q == Question columnNode 2262DuplicateBinned ColumnClean UpData ResultsGroup byUser ID( ROWS )Data to wideGroup byQn( COLUMNS )Data to wideCount User Scores Analysisby 'niveles' (Binnned CLASS)Count Qn Scores Analysisby 'niveles' (Binnned CLASS)Your Data12 Column RATING Questions 1-520 User ID Rows [Binned] countsto WIDEColumnValues [Binned]to WIDEAdd [Binned] chunkto WIDE formatAdd [Binned].counts chunkto WIDE formatAll PROCESSED dataWIDE formatColumn StatisticsNode 2287Mid-Upper boundmean+sdBin all the data in 3 cathegories:Nivel Bajo : [1 - (mean-sd) [Nivel Medio : [ (mean-sd) - (mean+sd) [Nivel Alto : [ (mean+sd) - P99 ] Overall Statistics Unpivoting Rule Engine GroupBy Java EditVariable (simple) Group Loop Start Column Filter Value Counter Joiner Loop End Sorter Sorter Rule Engine Column Filter GroupBy Pivoting GroupBy Pivoting Column Resorter Column Resorter DATA GENERATION Pivoting Pivoting Joiner Joiner Column Resorter Statistics Table Rowto Variable Java EditVariable (simple) Rule Engine Statistics @elsamuel 's solution: https://hub.knime.com/elsamuel/spaces/Public/latest/rsierrama%20-%20Count%20Values%20above%20threshold~oJyivGFe34DQGJhV: Outputs: Data to LONG format$ColumnValues$ > 5 => 1GroupBy IDAggreagate query using SumMid-Lower boundmean-sdLoop12 stepsSELECT 'Qn [Binned]'Count Qn [Binned]Add Qn [Binned].CountcolumnCollectDataSort by Qn Column*Q == Question columnNode 2262DuplicateBinned ColumnClean UpData ResultsGroup byUser ID( ROWS )Data to wideGroup byQn( COLUMNS )Data to wideCount User Scores Analysisby 'niveles' (Binnned CLASS)Count Qn Scores Analysisby 'niveles' (Binnned CLASS)Your Data12 Column RATING Questions 1-520 User ID Rows [Binned] countsto WIDEColumnValues [Binned]to WIDEAdd [Binned] chunkto WIDE formatAdd [Binned].counts chunkto WIDE formatAll PROCESSED dataWIDE formatColumn StatisticsNode 2287Mid-Upper boundmean+sdBin all the data in 3 cathegories:Nivel Bajo : [1 - (mean-sd) [Nivel Medio : [ (mean-sd) - (mean+sd) [Nivel Alto : [ (mean+sd) - P99 ] Overall Statistics Unpivoting Rule Engine GroupBy Java EditVariable (simple) Group Loop Start Column Filter Value Counter Joiner Loop End Sorter Sorter Rule Engine Column Filter GroupBy Pivoting GroupBy Pivoting Column Resorter Column Resorter DATA GENERATION Pivoting Pivoting Joiner Joiner Column Resorter Statistics Table Rowto Variable Java EditVariable (simple) Rule Engine Statistics

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: Loïc
Created at: 2021-04-23
On NodePit since: 2022-02-06
Last update: 2024-04-26
Created with KNIME version: v4.3.1

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

Try NodePit Runner!