Icon

Most likely period to increase v1

Personal choice (editable, if you want):if score is equal to 0, I consider it like amissing value.Like, that person has not taken the exam,so it's score is 0. There is no point incomputing a delta with a zero value,because it would be a fake improvement. Reading data Some ID are equal to 0I suppose it is a mistake andproceed to substitute themBringing years frommultiple columns to one(unpivoting)Renaming newcolumnsUnuseful columnSelecting oneID per iterationBy scoreascendingLagging scorecolumn to computedeltaDelta higherthan 50 points?Selecting yearswith delta improvementDelta yearsDelta yearsYear to numberMinimum yearVariable minimumyearRemoving first rowKeeping ID anddeltaYears onlySelecting oneID per iterationAverage by IDTotal averageExcel Reader Column Expressions Unpivoting Column Rename Column Filter Group Loop Start Sorter Lag Column Column Expressions Row Filter Lag Column Column Expressions String To Number Top k Selector Table Rowto Variable Row Filter Column Filter Loop End GroupBy GroupBy Personal choice (editable, if you want):if score is equal to 0, I consider it like amissing value.Like, that person has not taken the exam,so it's score is 0. There is no point incomputing a delta with a zero value,because it would be a fake improvement. Reading dataSome ID are equal to 0I suppose it is a mistake andproceed to substitute themBringing years frommultiple columns to one(unpivoting)Renaming newcolumnsUnuseful columnSelecting oneID per iterationBy scoreascendingLagging scorecolumn to computedeltaDelta higherthan 50 points?Selecting yearswith delta improvementDelta yearsDelta yearsYear to numberMinimum yearVariable minimumyearRemoving first rowKeeping ID anddeltaYears onlySelecting oneID per iterationAverage by IDTotal averageExcel Reader Column Expressions Unpivoting Column Rename Column Filter Group Loop Start Sorter Lag Column Column Expressions Row Filter Lag Column Column Expressions String To Number Top k Selector Table Rowto Variable Row Filter Column Filter Loop End GroupBy GroupBy

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: rbarri
Created at: 2022-08-19
On NodePit since: 2022-08-21
Last update: 2024-04-28
Created with KNIME version: v4.6.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!