There is a set of transaction data in which 6 events are cyclically repeated in a machine.
What I want to do is to allocate CASE ID automatically to a cycle of 6 events to distinguish each cycle and to conduct process mining.
The problem is that a cycle starts from EVENT1 and ends at EVENT6 in order every time, but sometimes EVENT1 starts before the previous cycle ends. Because of this it is not easy to distinguish each cycle by simple sorting.
I tried to use the Rank node, but I cannot build a proper workflow yet.
Attached sample data where CASE ID are allocated manually.20190920_sampledatacsv.xlsx (11.7 KB)
welcome to KNIME Community! Did you manage to solve your problem?
If not here is one idea. You have to mark first event in cycle (with unique identifier) and left other rows to be missing (?). Then use Missing Value node with Previous Value option. This way you will have same unique identifier for each event in cycle
Here is workflow example on KNIME Hub.
If any questions feel free to ask. Hope this helps!
