Greeting, I am a very new user of Knime. I would like help with Excel Spreadsheet. Attached here a sample of the spreadsheet. I just want to keep Pullin and last drop off of each run. (Highlighted rows). Please let me know how can I achieve the results. I would appreciate the help.
Here you go sir. The attached workflow solves your problem and it is fully commented for your convenience.
The key to the solution is to use a Moving Aggregation node plus some filtering and sorting. The last row requires some special care because... well it is the last row!
It amazes me that there is always a way to do things in KNIME, one just needs to be creative with what is available. ;-)
I forgot. Feel free to post again here if the way the worflow works in unclear to you.
Thank you Marco for you help, much appreciated.