Hello everyone, I have this issue, I want to detect missing numbers from a column.
my data is here missingTest.xlsx (8.4 KB)
here is my attempt in knime
I tried to use rule based row filter and rule based row splitter but no luck,
my ideal output is :
3
8
10, 11
13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33
The wf consist of two parts. In the first part the data-range to compare with your input is identified and created. Then the missing data-range is grouped In the second part.