Split tables depending on value differences in columns
Dear Knime Community,
I need to create subsets of a table depending on values in a column. The table is shown below. The column of interest is the “value” one. I need subset tables of 5 raws with values increasing by at least 5. For example, a subset table would be: ID 1,10,15,14,5. Because ID 10 (198) is >5 higher than ID 1 (190), ID 15 (205) is >5 higher than ID 10 (198), etc…
Another subset would also be 2, 12, 8, 11, 3.
Would you know a way how to do that ?
Many thanks in advance !
| ID | Value | Code |
| 1 | 190,1588 | 124863 |
| 2 | 190,2019 | 548685 |
| 3 | 234,001 | 524856 |
| 4 | 190,6738 | 526458 |
| 5 | 225,2875 | 526358 |
| 6 | 242,0726 | 586744 |
| 7 | 199,0081 | 985478 |
| 8 | 209,245 | 539874 |
| 9 | 201,1485 | 542868 |
| 10 | 198,2239 | 568425 |
| 11 | 222,4592 | 987568 |
| 12 | 198,6527 | 635241 |
| 13 | 272,7346 | 635245 |
| 14 | 217,2901 | 542865 |
| 15 | 205,2132 | 658965 |