This thread is for posting solutions to “Just KNIME It!” Challenge 14. 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 .
That was fun to do.
My solution uses a MovingAggregation node to do a cumulative computation from top to bottom and from bottom to top. So all values of 0 from both cumulative computations can be excluded from the file.
See: Challenge 14
Whoah! This is very surprising to me!
Hello KNIMErs,
Here is my solution to #justknimeit-14 :
KNIME Hub > gonhaddock > Spaces > Just_KNIME_It > Just KNIME It _ Challenge 014
My first thought was the Moving Aggregation similar to @HansS solution. Then, I ideate an alternative option based on the usability of ‘Missing Value’ nodes. Both are similar.
BR
You guys are killing it with the creativity today!
Hello everyone,
I struggled a little bit with lagging and stuff, so I decided to solve it using R.
I used a table creator node to modify the input table a little bit, just to be sure that even if you have a long list of zeros in the middle of the input, the model is not recognising it as noise.
justknimeit - 14 - Raffaello Barri
Have a nice evening,
RB
here’s my solution
My solution centers around calculating running sum in both directions and removing rows with zero (0). The default rowid’s cannot be numerically sorted (obviously), so I had to add a counter generation node to sort on.
cheers
We could invent a bicycle, but there is already a function to strip the string. So my solution is as simple as group > strip > collection/list > ungroup.
My first solution was to use a lag column and moving aggregation (for cumulative sum) to identify groups. Then I used a groupby node to find the max group number, which I filtered out if it was full of zeros. I decided that was all overkill since I was only interested in the last group, so used a switched to using a Moving Aggregation (again for cumulative sum) to identify leading zeros and flipped the data to do it on either end. Looks like my solution is almost identical to HansS’.
Super cool! I also had not thought about that!!!
Here’s my go at this. Not attempting to provide an efficient way, but merely an alternative solution; a unique approach to solve an integer-based issue using KNIME Text Processing partly.
Knime_Challenge_14_Answer_by_Badger101.knwf (116.9 KB)
Hi everyone,
Here is my solution.
Tried to solved it without variables.
Lots of different implementations that I’d never be able to come up myself. Good job! 
I did several variations. They all use the Moving Aggregation node for some reason:
Looking at all these imaginative solutions gave me some insights, then my challenge workflow has been upgraded from two to four different optional approaches. There’re tons of fun in this challenge, we could keep ideating approaches forever.
Tying to @Thyme 's, my four solutions:
Last one inspired from @MEPivnenko 's concatenate (I didn’t check into the code avoiding spoiler); then deepening into ‘non-greedy’ Regex code with some help from forum and @ipazin solution.
BR
My try on Challenge 14 - Easy as it seems … while on try it didnt seem so …
My first submission only removes the first and last zeros. This one works correctly. Thanks to Ivan Pazin for the regex I used.
REF Challenge 14 Rev 1.knwf (50.6 KB)
As always on Tuesdays, here’s our solution to last week’s challenge.
We did not modify it after seeing your super cool solutions just to add to the diversity here! 
See you tomorrow for a new challenge!
In this workflow, the data rows are first labeled as 0 and non 0. Then add them in a list, use the Column Expression node to find the first and last index of the non-0s. The first and last index are then transferred as flow variables “start” and “end”.
Then loop through the table row by row, and check if the current iteration number is within the range defined by the index “start” and “end” variables, and add the column “include”. The rows are then filtered out if they have a “false” value in the "include"column. Then remove the “include” column.
