Icon

20211026_​count_​higher_​than_​loopgroup

@elsamuel 's solution: https://hub.knime.com/elsamuel/spaces/Public/latest/rsierrama%20-%20Count%20Values%20above%20threshold~oJyivGFe34DQGJhV: $ColumnValues$ > 5 => 1GroupBy IDAggreagate query using SumLoop12 stepsBin all the data in 3 cathegories:Bin 1 : [ P01 - Q1 ]Bin 2 : ] Q1 - Q3 ]Bin 3 : ] Q3 - P99 ] 'Bin 3' value is currentlyyour 'nivel alto'*Q == QuartileSELECT 'Qn [Binned]'Count Qn [Binned]Add Qn [Binned].CountcolumnReplaceQn [Binned]CLASS (niveles)Binned to'niveles' dictionaryCollectDataSort by Qn Column*Q == Question columnNode 2262DuplicateBinned ColumnClean UpData ResultsGroup byUser ID( ROWS )Data to wideGroup byQn( COLUMNS )Data to wideCount User Scoresby 'niveles' (Binnned CLASS)Count Qn Scoresby 'niveles' (Binnned CLASS)Your Data12 Column RATING Questions20 User ID Rows Unpivoting Rule Engine GroupBy Group Loop Start Auto-Binner Column Filter Value Counter Joiner Cell Replacer Table Creator Loop End Sorter Sorter Rule Engine Column Filter GroupBy Pivoting GroupBy Pivoting Column Resorter Column Resorter DATA GENERATION @elsamuel 's solution: https://hub.knime.com/elsamuel/spaces/Public/latest/rsierrama%20-%20Count%20Values%20above%20threshold~oJyivGFe34DQGJhV: $ColumnValues$ > 5 => 1GroupBy IDAggreagate query using SumLoop12 stepsBin all the data in 3 cathegories:Bin 1 : [ P01 - Q1 ]Bin 2 : ] Q1 - Q3 ]Bin 3 : ] Q3 - P99 ] 'Bin 3' value is currentlyyour 'nivel alto'*Q == QuartileSELECT 'Qn [Binned]'Count Qn [Binned]Add Qn [Binned].CountcolumnReplaceQn [Binned]CLASS (niveles)Binned to'niveles' dictionaryCollectDataSort by Qn Column*Q == Question columnNode 2262DuplicateBinned ColumnClean UpData ResultsGroup byUser ID( ROWS )Data to wideGroup byQn( COLUMNS )Data to wideCount User Scoresby 'niveles' (Binnned CLASS)Count Qn Scoresby 'niveles' (Binnned CLASS)Your Data12 Column RATING Questions20 User ID Rows Unpivoting Rule Engine GroupBy Group Loop Start Auto-Binner Column Filter Value Counter Joiner Cell Replacer Table Creator Loop End Sorter Sorter Rule Engine Column Filter GroupBy Pivoting GroupBy Pivoting Column Resorter Column Resorter DATA GENERATION

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!