Solutions to “Just KNIME It!” Challenge 26 - Season 2

:boom: New Wednesday, new Just KNIME It! challenge! :boom:

:exploding_head: This week we have our last easy challenge of the season! :money_with_wings: Join us and solve a sales management task to hone your data preprocessing skills. :thinking_face: How much can you simplify your solution?

:mega: This season we will have 30 challenges, so it’s fair to say we can already see the end of it coming! :running_woman: Time to tackle old challenges and score your way into our leaderboard! :trophy:

Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason2-26.

:sos: Need help with tags? To add tag JKISeason2-26 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. :slight_smile: Let us know if you have any problems!

1 Like

Here’a my solution - table and line chart.


Here you go!

KNIME Solution using Column Expressions / Lag & Math Nodes


Output Table

Line Plot


Hi all,
This is my solution.
Cells in the table are colored according to the percentage increase or decrease in sales.


Hello knimers,
This is my take to the challenge:

Happy Knim(e)ing


Welcome back, @gonhaddock! I am thrilled to see you here again.


Happy KNIMing :kissing_closed_eyes: :kissing_closed_eyes: :kissing_closed_eyes: :kissing_closed_eyes:


Hello @MoLa_Data
I’ve been very busy these days with work + logistics… then I couldn’t follow up the JKI Challenges as I would like, by delivering out of the box solutions. This CH26 was an easy one, so it didn’t require too much from my side.

I have a couple of unfinished past challenges in my desktop. I would like to complete them before season ends; now that northern hemisphere’s summer already passed away.

salu2 :vulcan_salute:t4:


The ‘Column Expressions’ node is a magical node that can replace the’ Math ‘node, the’ String Manipulation ‘node, and even the’ Lag Column 'node. We can also program multiple lines and only return the last line, which can also be annotated.

Thank you to @skybe077 for sharing, and also to @sryu for sharing the processing skills of the “Lag Column” node.

Note: The use of the ‘Column Expressions’ node requires coding, but the advantage is that it can simplify the flowchart.


No problem! That node was a game changer for me.


Find herewith my submission for challenge 26


Hi Everyone :slight_smile:

I have done much the same as everyone else this week:

I was inspired by @MoLa_Data to use a stacked bar chart so that the total percentage change for each month can be viewed:

Thanks also to those of you who shared solutions with the -Column Expressions- node, that was interesting to see!

My solution is here:

Best wishes


:sparkles: As always on Tuesdays, but a little later today due to technical issues, here’s our solution to last week’s Just KNIME It! challenge :sparkles:

:arrows_counterclockwise: As you can see, our solution relies mostly on a basic loop and lagging operations. :blush: Easy peasy! We hope this last easy challenge felt inclusive and honed you a bit for our final stretch. :running_woman: We only have 4 more challenges to go!


Lots of loop-free solutions! I like it. :smiley:

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.