# Solutions to “Just KNIME It!” Challenge 29 - Season 4

**URL:** <https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894>\
**Category:** JKI Season 4\
**Created:** [December 3, 2025, 2:51pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894 "2025-12-03T14:51:04Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![forum](https://forum-cdn.knime.com/user_avatar/forum.knime.com/forum/32/77398_2.png) [@forum](https://forum.knime.com/u/forum)\
**Post date:** [December 3, 2025, 2:51pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/1 "2025-12-03T14:51:04Z")

</div>

🌞 Happy Wednesday, folks! 🌞

🦃 After our Thanksgiving break, we’re back with another Just KNIME It! challenge on data wrangling and cleaning. 🧹 ⚙ Get ready to dive deep in missing value imputation and data type reformatting, even counting on LLMs to help along the way. 🧠 This challenge errs towards the hard side, and we hope you learn a lot by solving it!

[Here](https://www.knime.com/just-knime-it) is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public [KNIME Hub](https://hub.knime.com/) spaces with tag **JKISeason4-29**.

🆘 **Need help with tags?** To add tag JKISeason4-29 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. 😊 Let us know if you have any problems!

---

<div class="post-metadata">

**Author:** ![AnilKS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anilks/32/52258_2.png) [@AnilKS](https://forum.knime.com/u/AnilKS)\
**Post date:** [December 3, 2025, 4:54pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/2 "2025-12-03T16:54:19Z")

</div>

Find herewith my submission : [JKISeason4-29 – KNIME Community Hub](https://hub.knime.com/s/GZoqaduQOSSeQ2UV)

Very well elaborated while links and data seems not linked so got bit puzzled .. Link to submission took to 2/4 .Hope the brief ask is captured in solution as read.

Reclassified Table of Top -3 ( as chosen) under representative category is reclassified as below.

 ![table view](https://forum-cdn.knime.com/uploads/default/original/3X/2/5/25be133bf3fcece30c0562ee2b04319e3bbdc2c9.png)

 ![flow](https://forum-cdn.knime.com/uploads/default/original/3X/c/c/cc4907273c7e138367f150e711048e1569cb0c17.png)

 ![Price by Cat](https://forum-cdn.knime.com/uploads/default/original/3X/a/b/ab88f73b9d4851451a5a5fa0a2bacc6bbdb2251d.png)

 ![top 5 under rep cat](https://forum-cdn.knime.com/uploads/default/original/3X/8/8/886937ec2544e602ebfcba07edf78a783c1180ed.png)

---

<div class="post-metadata">

**Author:** ![AnilKS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anilks/32/52258_2.png) [@AnilKS](https://forum.knime.com/u/AnilKS)\
**Post date:** [December 3, 2025, 4:56pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/3 "2025-12-03T16:56:43Z")

</div>

Link for solution is redirecting to [Solutions to “Just KNIME It!” Challenge 2 - Season 4](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-2-season-4/88065?pk_vid=36b0b9855e16d9f517647809311dfa08) ?

---

<div class="post-metadata">

**Author:** ![alinebessa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alinebessa/32/33306_2.png) [@alinebessa](https://forum.knime.com/u/alinebessa)\
**Post date:** [December 3, 2025, 7:48pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/5 "2025-12-03T19:48:02Z")

</div>

Hi, Anil! When I clicked on your solution link I went to the right place. What link is redirecting to this forum entry?

Thanks!

---

<div class="post-metadata">

**Author:** ![berti093](https://forum-cdn.knime.com/user_avatar/forum.knime.com/berti093/32/61891_2.png) [@berti093](https://forum.knime.com/u/berti093)\
**Post date:** [December 3, 2025, 8:01pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/6 "2025-12-03T20:01:10Z")

</div>

Huhh, this was quite a challenge. I did use nodes that I didn’t use in a long time. I really really enjoyed it. I said in this season couple of times now but I think I loved this challenge the most 😃

My solution to the challenge:

> **[JKISeason4-29\_berti093 – berti093](https://hub.knime.com/berti093/spaces/Public/Just%20KNIME%20it%20S04/JKISeason4-29_berti093~VygiH5V-9KLMGzNC/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

My workflow (as it can be seen it is quite complex 😃 ):

[![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/0/f0c1a8a3a61ab47e950f90b5879a839cc778e929.png)](https://forum-cdn.knime.com/uploads/default/original/3X/f/0/f0c1a8a3a61ab47e950f90b5879a839cc778e929.png "image")

My approach:

- Loading the two Excel sheets and preprocess it

- I have visualized the price by category

- I have removed the outliers regarding price in every category (group loop and numeric outliers nodes)

- Created a composite metric that ranks the products

- I identified underrepresented categories

- After that I connected to my local Falcon LLM and asked what other category (from the remaining categories) should the product in these categories belong to

- I compared the two “categories”. There is not much of a different, but the Gaming Keyboards category got bigger

- And finally I just wrote the Excel out (now to my desktop)

This was one of the biggest challenges of the season and as I said I think it is my favoritue (TOP3 that’s for sure 😃 ). I loved how it forced me to use long forgotten nodes 🙂

Love (sadly soon: Loved) this season! 🙂

---

<div class="post-metadata">

**Author:** ![berti093](https://forum-cdn.knime.com/user_avatar/forum.knime.com/berti093/32/61891_2.png) [@berti093](https://forum.knime.com/u/berti093)\
**Post date:** [December 3, 2025, 8:02pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/7 "2025-12-03T20:02:36Z")

</div>

I think Anil is mentoining this button:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/6/3/632b2ed1daff6dd6743c90adef7e4cdaf0e0d06c.png)

For me it goes to here as well:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/9/c/9c628376f5af12eb6890829854d6d5c9da6f397b.png)

---

<div class="post-metadata">

**Author:** ![alinebessa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alinebessa/32/33306_2.png) [@alinebessa](https://forum.knime.com/u/alinebessa)\
**Post date:** [December 3, 2025, 10:23pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/8 "2025-12-03T22:23:53Z")

</div>

Huh, this is awkward – it’s coming to this page for me! Can you folks try to clean your cookies, or open on an incognito tab? If you still gets this error, please let me know and I’ll talk to our website team!

---

<div class="post-metadata">

**Author:** ![AnilKS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anilks/32/52258_2.png) [@AnilKS](https://forum.knime.com/u/AnilKS)\
**Post date:** [December 4, 2025, 12:48am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/9 "2025-12-04T00:48:18Z")

</div>

Ohh?? I tried… must be issue at my end . anyway.. good if it’s working well.

---

<div class="post-metadata">

**Author:** ![trj](https://forum-cdn.knime.com/user_avatar/forum.knime.com/trj/32/17643_2.png) [@trj](https://forum.knime.com/u/trj)\
**Post date:** [December 4, 2025, 6:35am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/10 "2025-12-04T06:35:58Z")

</div>

Hi all,

My solution is available here: [JKISeason 4-29 - Preparing Your Office Equipment Data – KNIME Community Hub](https://hub.knime.com/s/2dj2-8za3aHC9Rat)

Thanks @berti093 for the LLM Prompt! 🙂

Interesting as always to get to use many different nodes.

Cheers all

Jerome

---

<div class="post-metadata">

**Author:** ![ActionAndi](https://forum-cdn.knime.com/user_avatar/forum.knime.com/actionandi/32/76198_2.png) [@ActionAndi](https://forum.knime.com/u/ActionAndi)\
**Post date:** [December 5, 2025, 4:26pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/11 "2025-12-05T16:26:37Z")

</div>

Hi @berti093 ,

brilliant workflow as allways.

Do you know that there is a “Group Settings” tab in the numeric outliers node?  
With this setting you can avoid the "“group loop” construct in your workflow

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/e/ced828498a7c8f1b2dc5a714d84c39ec2a264897.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/7/b7368c2776ea548b9111eedc3f75e2506551d307.png)

Best,  
Andreas

---

<div class="post-metadata">

**Author:** ![jproudfoot111](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/7bcc69/32.png) [@jproudfoot111](https://forum.knime.com/u/jproudfoot111)\
**Post date:** [December 5, 2025, 5:37pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/12 "2025-12-05T17:37:56Z")

</div>

> **[JKISeason4-29 – jproudfoot111](https://hub.knime.com/jproudfoot111/spaces/Public/JKISeason4-29~OdVdh-dk3PSeIxpy/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

This one turned into a bit of a Rube Goldberg machine but got to a solution in the end…

 ![4-29](https://forum-cdn.knime.com/uploads/default/original/3X/8/a/8a9fb6726bf89b80635d05e03b5ac9ba66d243ae.png)

---

<div class="post-metadata">

**Author:** ![berti093](https://forum-cdn.knime.com/user_avatar/forum.knime.com/berti093/32/61891_2.png) [@berti093](https://forum.knime.com/u/berti093)\
**Post date:** [December 5, 2025, 8:17pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/13 "2025-12-05T20:17:42Z")

</div>

Thank you Andreas!

And thank you for highlighting that! I didn’t know about it 😮 Really good to learn new (and more efficient) approaches! 🙂

---

<div class="post-metadata">

**Author:** ![alpayzeybek](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alpayzeybek/32/78562_2.png) [@alpayzeybek](https://forum.knime.com/u/alpayzeybek)\
**Post date:** [December 6, 2025, 1:32pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/14 "2025-12-06T13:32:11Z")

</div>

I’ve completed the entire workflow and wanted to share my experience.  
For the final categorization step, I used the **OpenAI API** integrated directly into KNIME, which worked remarkably well after some careful prompt tuning.

I’d like to share a couple of screenshots and my KNIME Hub flow so others can review, test, or improve on it.

This exercise was incredibly insightful — especially in understanding how LLMs behave inside a structured data pipeline, and how important strict prompting and validation become when automating classification tasks.

Thanks again to everyone involved. Happy to iterate further or discuss improvements!

Best,

Alpay Zeybek

> **[JustKnimeIt\_S4EP29 – alpayzeybek](https://hub.knime.com/alpayzeybek/spaces/Public/JustKnimeIt_S4EP29~AWf7wFBRvsjlcdHG/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/6/a/6ab003193ac462b7778e2dda604a966f101aca56.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/7/7/7711904746da59614ba9db6871b86ae2ee278325.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/a/aad8b744b88d35fc05234e73bce5c30d6f9b17f1.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/2/c23a45bd52c6dea690ce29bafe116188e7c36dc0.png)

---

<div class="post-metadata">

**Author:** ![rfeigel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7ea924/32.png) [@rfeigel](https://forum.knime.com/u/rfeigel)\
**Post date:** [December 7, 2025, 4:01am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/15 "2025-12-07T04:01:10Z")

</div>

Here’s my solution. I made no attempt to integrate a LLM. Joined some of the categories and created a ranking based on Mean Review Score, Price and Rating. Their order can be changed as the user sees fit.

> **[JKISeason4-29 – rfeigel](https://hub.knime.com/rfeigel/spaces/Public/JKISeason4-29~66muJCSWASb-5AkF/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

 ![workflow](https://forum-cdn.knime.com/uploads/default/original/3X/6/c/6c98c881324a847171ccb4974b9e7a8cd021c882.jpeg)

 ![output](https://forum-cdn.knime.com/uploads/default/original/3X/f/d/fd598876a8ffb358613fb61d515599a635efa2bb.jpeg)

---

<div class="post-metadata">

**Author:** ![garcbcpa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/garcbcpa/32/74679_2.png) [@garcbcpa](https://forum.knime.com/u/garcbcpa)\
**Post date:** [December 7, 2025, 4:15am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/16 "2025-12-07T04:15:17Z")

</div>

Greetings KNIMERs

Here is my attempted solution to this week’s challenge:

> **[Challenge 29-Preparing Your Office Equipment Data – garcbcpa](https://hub.knime.com/garcbcpa/spaces/Public/Just%20Knime%20It%20Season%204/Challenge%2029-Preparing%20Your%20Office%20Equipment%20Data~mlfgB8jdZbCRhCVQ/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

This challenge is taking the integration with LLMs to another level and it was great to up-skill my knowledge in this area. I don’t know when I’ll need this knowledge but i’m sure the opportunity will eventually present itself.

here is the output file with the integration of LLM for new/updated categories.

[LLM Output-Full Dataset.xlsx](https://forum.knime.com/uploads/short-url/7wXkq12Fi4ZcAxwo25O0Lqv2KcB.xlsx) (1.2 MB)

I tried to address the other queries in the challenge as well.

LLM Visualizations:

 ![Screenshot 2025-12-06 at 10.10.47 PM](https://forum-cdn.knime.com/uploads/default/original/3X/6/6/66438846aeb1702e6e32c3b67d3231f8259a732b.png)

Under-represented categories

 ![Screenshot 2025-12-06 at 10.11.12 PM](https://forum-cdn.knime.com/uploads/default/original/3X/7/2/72a7f44e9a90beb3b06437883b28a169da9764aa.png)

Price & Rating by Titles

 ![Screenshot 2025-12-06 at 10.11.42 PM](https://forum-cdn.knime.com/uploads/default/original/3X/c/2/c214d7ce27ab05ebaf7728b5167beb11929a68a1.png)

Price by Category

 ![Screenshot 2025-12-06 at 10.12.41 PM](https://forum-cdn.knime.com/uploads/default/original/3X/3/2/3248143fc4d38265ee6269e0297661f7cbfe18fc.png)

Cheers

---

<div class="post-metadata">

**Author:** ![trj](https://forum-cdn.knime.com/user_avatar/forum.knime.com/trj/32/17643_2.png) [@trj](https://forum.knime.com/u/trj)\
**Post date:** [December 8, 2025, 10:43am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/17 "2025-12-08T10:43:51Z")

</div>

Hi @armingrudd

I realised I didn’t use the right tag…

Could you check that the workflow will be taken in account ?

Thanks

Cheers

---

<div class="post-metadata">

**Author:** ![armingrudd](https://forum-cdn.knime.com/user_avatar/forum.knime.com/armingrudd/32/84633_2.png) [@armingrudd](https://forum.knime.com/u/armingrudd)\
**Post date:** [December 8, 2025, 10:54am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/18 "2025-12-08T10:54:55Z")

</div>

Hello @trj,

Of course it will! You just need to wait for the next DB update run and then leaderboard update. The leaderboard should get updated by tomorrow noon latest. If not, please let me know.

---

<div class="post-metadata">

**Author:** ![dataloca](https://forum-cdn.knime.com/user_avatar/forum.knime.com/dataloca/32/78464_2.png) [@dataloca](https://forum.knime.com/u/dataloca)\
**Post date:** [December 8, 2025, 5:18pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/19 "2025-12-08T17:18:54Z")

</div>

Hello everyone,

Interesting Knime Challenge! I have discovered the Numeric Outliers node and practiced LLM prompting. Thanks for the challenge. [Here](https://hub.knime.com/dataloca/spaces/Public/Just%2520Knime%2520It/JKISeason4-29%2520Office%2520Equipment%2520Data~utzEIRZaXoXVmiLy/current-state)is my solution.

 ![JKISeason4-29](https://forum-cdn.knime.com/uploads/default/original/3X/b/e/be4f4b1430bf38da920a1e1f3945df0f57d5b41a.png)

---

<div class="post-metadata">

**Author:** ![trj](https://forum-cdn.knime.com/user_avatar/forum.knime.com/trj/32/17643_2.png) [@trj](https://forum.knime.com/u/trj)\
**Post date:** [December 9, 2025, 8:54am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/20 "2025-12-09T08:54:06Z")

</div>

Hi @armingrudd

Just a head up, the leaderboard seems still out. Latest refresh is yesterday / just mindful if the solution will be taken in account.?

Thanks

---

<div class="post-metadata">

**Author:** ![armingrudd](https://forum-cdn.knime.com/user_avatar/forum.knime.com/armingrudd/32/84633_2.png) [@armingrudd](https://forum.knime.com/u/armingrudd)\
**Post date:** [December 9, 2025, 9:22am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894/21 "2025-12-09T09:22:18Z")

</div>

Oh, sorry for the confusion, I meant CET time zone. which gives it about 2 hours to update!  
I just checked and can confirm that it has been updated in DB and the leaderboard updates at noon CET everyday.

[Next page](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-29-season-4/90894.md?page=2)
