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:
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!