This thread is for posting solutions to “Just KNIME It!” Challenge 15 (yes! 15 challenges already!!). Feel free to link your solution from KNIME Hub as well!
Here is the challenge of the week: Just KNIME It! | KNIME
Have an idea for a challenge? We’d love to hear it! 
Feel free to write it here .
And remember: the more you participate, the more participation badges you may end up getting. Fancy, huh? 
Just remember to correctly mark your solution in the Hub with tag justknimeit-15. 
Hello Knimers,
this is my solution: justknimeit - 15 - Raffaello Barri – KNIME Hub
I added a variable, so that the table to be read can vary in lenght. Also, I read the columns up to the last one.
Have a nice day,
RB
Here’s my solution
Did two versions. One where I tried to automate as much as possible i.e.
Second version I tried to limit no. of nodes sacrificing the dynamic part. I managed solving the challenge using 8 nodes.
cheers
Fun little test. Here is my submission I did it in 7 nodes. I will admit I came up at first with same solution as @elsamuel so I went back and see if I could try something different. So I cheated the insert header column by exporting to csv without the header and reading it back in saying it had a header. I split on spaces and used the transform in the csv reader to eliminate columns and get numbers typed correctly as integers. Two executes but it gets you there.
Hi everyone,
here is my solution
I kept the last rows (sum ,avg) but it can be easily removed.
Hello everyone !
My solution to this very interesting challenge.
I processed the input a bit further so we can have the full table to analyze !
This is my solution, it is partly based on what was done by @walkergv77 and @Milks, each proposal has problems with its solutions.
@AnilKS generates a mistake when splitting, and the final result show, that it is not present the exact columns requested on the challenge.
@walkergv77 when writing the solution to XLS, include the AVG column and omit the COOL column
I have extended it to all available columns in the table.I used regex to fix irregularity in direction column.
10 nodes as requested. No cheating.
As always on Tuesdays, here’s our solution to #justknimeit challenge 15! 
I hope you learned something useful this week! In my opinion this is data wrangling at its finest hehe
See you tomorrow for a new challenge!
Hello KNIMErs, it’s better late than never!
Here is my solution to #justknimeit-15 :
KNIME Hub > gonhaddock > Spaces > Just_KNIME_It > Just KNIME It _ Challenge 015
It’s been unavoidable to get insights from previous solutions (thanks for it). Specially the cool Cell Splitter to list and Ungroup… great to apply here.
BR
