Icon

2019_​11_​27_​Cycle_​Determination

Cycle Determination
Cycle DeterminationThis workflow determines which event belongs to same cycle and assigns unique identifier for each cycle. This is done bymarking first event in each cycle with unique identifier and then populating other events using Missing Value node. If everycycle begins with same event number (1) then determening is easy and done in bottom branch. If not then determinationis done by comparing current event row value to following event value and is done in upper branch.Forum link: https://forum.knime.com/t/how-to-allocate-case-id/18166 Bottom branch - Cycle always starts with 1 Upper branch - Cycle doesn't need to start with 1 Input dataAssign unique ID to first event in each cycleLag EVENT IDPopulate events from same cycleAssign unique ID to first event in each cyclePopulate events from same cycleExcel Reader (XLS) Rule Engine Lag Column Missing Value Rule Engine Missing Value Cycle DeterminationThis workflow determines which event belongs to same cycle and assigns unique identifier for each cycle. This is done bymarking first event in each cycle with unique identifier and then populating other events using Missing Value node. If everycycle begins with same event number (1) then determening is easy and done in bottom branch. If not then determinationis done by comparing current event row value to following event value and is done in upper branch.Forum link: https://forum.knime.com/t/how-to-allocate-case-id/18166 Bottom branch - Cycle always starts with 1 Upper branch - Cycle doesn't need to start with 1 Input dataAssign unique ID to first event in each cycleLag EVENT IDPopulate events from same cycleAssign unique ID to first event in each cyclePopulate events from same cycleExcel Reader (XLS) Rule Engine Lag Column Missing Value Rule Engine Missing Value

Nodes

Extensions

Links