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