Hello folks,

I joined the Knime universe right this spring at Berlin and I am currently digging into the whole thing.

And my problems do not seem to end. Found a lot of sollutions already, but for this one I do not get working.

I got a table with analyses for batches.

It looks like the following:

Date / Batch / Sample Number / Element 1 / β¦ / Element n

I got seveal samples for each batch, usually looking like that:

1

2

3

14

15

20

21

22

31

The single digit samples are for my first unit, the two digits starting with 1 (14, 15β¦) are for the second unit, the 20s are for the third and 31 is the final sample.

Problem: They are not always the same. It could start with a 2 or 3 for example, have between 2 and 6 samples on the unit 2 and so on.

The first sample of unit 2 is made with the pattern β(largest sample number unit 1) + 11β so after 4 follows sample 15.

Hope I made this clear.

And now the problem:

I need to filter the table for the following criteria:

- first sample for each batch (lowest sample number).
- first sample of unit 2 (lowest sample number >10)
- last sample of unit 2 (highest sample number <20)
- first sample of unit 3 (usually 20 but make it lowest sample number >=20).
- final sample (31)

Hope someone of can help me.

I guess the sollution is simple, but somehow I do not get that working for me.

Thanks in Advance!

Regards

Michael