Extract missing value from a column

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
knime1

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

Hi @spyglass

I think you need a couple of nodes more to have a successful attempt. See this wf
extract missing numbers from column.knwf (66.1 KB) .


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.

gr. Hans

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.