Excel Help

Hello All,

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. ;-)

Cheers,
Marco.

I forgot. Feel free to post again here if the way the worflow works in unclear to you.

Cheers,
Marco.

Thank you Marco for you help, much appreciated. 

 

Gurpreet