# Solutions to "Just KNIME It!" Challenge 01 -- Season 2

**URL:** <https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474>\
**Category:** Just KNIME It!\
**Tags:** justknimeit\
**Created:** [March 29, 2023, 1:53pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474 "2023-03-29T13:53:55Z")\
**Posts on this page:** 20\
**Page:** 1

<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:** [March 29, 2023, 1:53pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/1 "2023-03-29T13:53:56Z")

</div>

💥 We’re finally back for the second season of our weekly _Just KNIME It!_ challenges, folks! 💥

This thread is for posting solutions to Season 2’s Challenge 01. We kick off our season with a challenge on exchange rates, which blends time series 📈, correlation analysis, and data visualization 🔍.

Here is the challenge: [Just KNIME It! | KNIME](https://www.knime.com/just-knime-it)

Feel free to link your solution from [KNIME Community Hub](https://hub.knime.com/) here as well!

And as always, if you have an idea for a challenge we’d love to hear it! 😍 Tell us all about it [here](https://forum.knime.com/t/community-just-knime-it-challenges/40506).

Here is the challenge: [Just KNIME It!](https://www.knime.com/just-knime-it)

Feel free to link your solution from [KNIME Hub](https://hub.knime.com/)as well!

 ![chart](https://forum-cdn.knime.com/uploads/default/original/3X/b/8/b87ac017e16255fba2028e92ba8aa10b3ca6e6b8.png)

---

<div class="post-metadata">

**Author:** ![sammyhallgren](https://forum-cdn.knime.com/user_avatar/forum.knime.com/sammyhallgren/32/15011_2.png) [@sammyhallgren](https://forum.knime.com/u/sammyhallgren)\
**Post date:** [March 30, 2023, 7:14am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/2 "2023-03-30T07:14:29Z")

</div>

Could it be I’m the first to post for the first challenge? Making KNIME history here! 🙂

Well quick may not necessarily be a good thing but I hope its meets the solution criteria and inspire to even greater solutions: [Challenge 01 - Comparing Exchange Rates – KNIME Community Hub](https://hub.knime.com/sammyhallgren/spaces/Public/latest/Challenge%2001%20-%20Comparing%20Exchange%20Rates~H7Yb3_S1NWGkVhrL)

---

<div class="post-metadata">

**Author:** ![alxpei77](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alxpei77/32/52183_2.png) [@alxpei77](https://forum.knime.com/u/alxpei77)\
**Post date:** [March 30, 2023, 11:02am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/3 "2023-03-30T11:02:48Z")

</div>

Silver medal for me… 😁  
Same for me…I hope the solution meets the requirements.  
Looking forward best solutions idea…

[JNI - Challenge 01](https://hub.knime.com/alxpei77/spaces/PubSp/latest/JKISeason2-1~shpn9yRxpmjw2vqp)

---

<div class="post-metadata">

**Author:** ![corgikenhouse](https://forum-cdn.knime.com/user_avatar/forum.knime.com/corgikenhouse/32/53343_2.png) [@corgikenhouse](https://forum.knime.com/u/corgikenhouse)\
**Post date:** [March 30, 2023, 12:25pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/4 "2023-03-30T12:25:27Z")

</div>

1st post in KNIME forum !  
Nice to meet you and it would be great if we could help each other improve.

> **[Just KNIME it-2\_Challenge-01\_v1 – corgikenhouse](https://hub.knime.com/corgikenhouse/spaces/Public/latest/Just%20KNIME%20it%202/Just%20KNIME%20it-2_Challenge-01_v1~NetZ01zhalt2pDRf)**
>
> https://www.knime.com/just-knime-it 1st challenge in Just KNIME it-2 1980年から1998年までの米ドルと他の8つの国の通貨の為替レートを比較したもの

---

<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:** [March 30, 2023, 3:04pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/5 "2023-03-30T15:04:04Z")

</div>

Here’s my solution. Only tricky part is handing the diagonals when calculating the maximum correlation.

> **[JKISeason2-1 – rfeigel](https://hub.knime.com/rfeigel/spaces/Public/latest/JKISeason2-1~zIimSW_vjGB1N_yH)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

---

<div class="post-metadata">

**Author:** ![sryu](https://forum-cdn.knime.com/user_avatar/forum.knime.com/sryu/32/60147_2.png) [@sryu](https://forum.knime.com/u/sryu)\
**Post date:** [March 30, 2023, 3:20pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/6 "2023-03-30T15:20:41Z")

</div>

The value of the start date of aggregation for each currency is set as 1 in the line chart.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/d/0d64fa5168e4cfcdc9ec23a07db221e86553c55c.jpeg)

In addition, any period of time can be selected for aggregation.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/5/6/5681bce499d3b166f1517dba550c0e6733899119.jpeg)

> **[JKISeason2-1 ver2 – sryu](https://hub.knime.com/sryu/spaces/Public/latest/Just%20KNIME%20It%20season2/JKISeason2-1_sryu_ver2~iwJlQIUV3VN7FDJ3)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

---

<div class="post-metadata">

**Author:** ![HaveF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/havef/32/1124_2.png) [@HaveF](https://forum.knime.com/u/HaveF)\
**Post date:** [March 30, 2023, 4:16pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/7 "2023-03-30T16:16:30Z")

</div>

Just use log view 😄 to see Correlations

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/5/157684deb5f79fd4f8f3325f540b28e34b903bb1.png)

> **[C01 – havef](https://hub.knime.com/havef/spaces/Public/latest/Just_KNIME_It/S2/C01~yxEXOb0fp67J-Kqn)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

---

<div class="post-metadata">

**Author:** ![lelloba](https://forum-cdn.knime.com/user_avatar/forum.knime.com/lelloba/32/43992_2.png) [@lelloba](https://forum.knime.com/u/lelloba)\
**Post date:** [March 30, 2023, 4:51pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/8 "2023-03-30T16:51:47Z")

</div>

Hello Knimers,

here’s my solution to the challenge:

> **[justknimeit02 - 01 - Raffaello Barri – lelloba](https://hub.knime.com/lelloba/spaces/Public/latest/Just%20Knime%20it!/Season_02/justknimeit02%20-%2001%20-%20Raffaello%20Barri~8Sgs0IQAoJNn0yoc)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

- Heatmap to emphasise stongest positive correlations between currencies;
- Table summarising all correlation results calculated;
- Filter widgets
  - Date interval selection
  - Currency checklist

- Double line chart:
  - With normal values
  - Values corrected with log(), since the Japanese Yen has much higher values compared to other currencies’ ones.

Have a nice evening,  
Raffaello

---

<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:** [March 30, 2023, 5:43pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/9 "2023-03-30T17:43:14Z")

</div>

@sryu Well done! Very sophisticated.

---

<div class="post-metadata">

**Author:** ![Artem](https://forum-cdn.knime.com/user_avatar/forum.knime.com/artem/32/47971_2.png) [@Artem](https://forum.knime.com/u/Artem)\
**Post date:** [March 30, 2023, 6:38pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/10 "2023-03-30T18:38:05Z")

</div>

> **[JKISeason2-1 – artem](https://hub.knime.com/artem/spaces/Public/latest/JK/JKISeason2-1~Qbm3L5UjK-zFMayW)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

---

<div class="post-metadata">

**Author:** ![elimisael](https://forum-cdn.knime.com/user_avatar/forum.knime.com/elimisael/32/63413_2.png) [@elimisael](https://forum.knime.com/u/elimisael)\
**Post date:** [March 30, 2023, 10:00pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/11 "2023-03-30T22:00:32Z")

</div>

I see several post solutions, and study some missing values methods to complete the rows missed, I finished the present solution

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

The flow is on the following URL [JKISeason2-1 – KNIME Community Hub](https://hub.knime.com/elimisael/spaces/Public/latest/Just%20Knime%20It/Season%2002/JKISeason2-1/JKISeason2-1)

- Double line chart:
  - With normalized values
  - Values corrected with log(), since the Japanese Yen has much higher values than other currencies.

- Table summarising all correlation results calculated

---

<div class="post-metadata">

**Author:** ![HaveF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/havef/32/1124_2.png) [@HaveF](https://forum.knime.com/u/HaveF)\
**Post date:** [March 31, 2023, 11:47am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/12 "2023-03-31T11:47:15Z")

</div>

For some users who can speak Chinese, [check out my video on youtube](https://youtu.be/4MTMWn3W9Ho). Because the production of the video is a bit time consuming, I can’t guarantee that there will be another video like this in the future. Let me share this one first.

---

<div class="post-metadata">

**Author:** ![KNIMEST](https://forum-cdn.knime.com/user_avatar/forum.knime.com/knimest/32/28197_2.png) [@KNIMEST](https://forum.knime.com/u/KNIMEST)\
**Post date:** [March 31, 2023, 12:27pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/13 "2023-03-31T12:27:17Z")

</div>

@corgikenhouse  
Welcome to JKI, let’s have fun together.  
The workflow you posted, you need to set the Tag to “JKISeason2-1” ( # isn’t needed) to be considered as a participant.

---

<div class="post-metadata">

**Author:** ![KNIMEST](https://forum-cdn.knime.com/user_avatar/forum.knime.com/knimest/32/28197_2.png) [@KNIMEST](https://forum.knime.com/u/KNIMEST)\
**Post date:** [March 31, 2023, 1:06pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/14 "2023-03-31T13:06:31Z")

</div>

@sryu  
I marvelled at the level of visualisation and you probably solved this challenge faster than anyone else in the world.

---

<div class="post-metadata">

**Author:** ![sryu](https://forum-cdn.knime.com/user_avatar/forum.knime.com/sryu/32/60147_2.png) [@sryu](https://forum.knime.com/u/sryu)\
**Post date:** [March 31, 2023, 2:00pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/15 "2023-03-31T14:00:12Z")

</div>

@rfeigel  
Thank you for your compliments.

---

<div class="post-metadata">

**Author:** ![sryu](https://forum-cdn.knime.com/user_avatar/forum.knime.com/sryu/32/60147_2.png) [@sryu](https://forum.knime.com/u/sryu)\
**Post date:** [March 31, 2023, 2:01pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/16 "2023-03-31T14:01:39Z")

</div>

@KNIMEST  
Your praise is much appreciated. I posted earliest to KNIME Hub as you indicated. However, I was not satisfied with it, so I created ver2 and then posted it on this forum.

---

<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:** [March 31, 2023, 3:28pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/17 "2023-03-31T15:28:44Z")

</div>

Whoah! The solutions you folks are posting are nothing short of incredible! Thank you so much for keeping us on our toes!

---

<div class="post-metadata">

**Author:** ![l6fader](https://forum-cdn.knime.com/user_avatar/forum.knime.com/l6fader/32/53149_2.png) [@l6fader](https://forum.knime.com/u/l6fader)\
**Post date:** [April 1, 2023, 2:27am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/18 "2023-04-01T02:27:20Z")

</div>

Here is my solution for **JKISeason2-1** : [Challenge 01\_Comparing Exchange Rates\_LDF](https://hub.knime.com/-/spaces/-/latest/~lI3TXm9boP4SQAdk/)

It’s pretty simple compared to some of the others, but it was fun to crack out quickly. Thank you to everyone else who contributed. I learned a few things along the way…

This is my first post ever on the KNIME Hub. Really happy to give JKI a try.

---

<div class="post-metadata">

**Author:** ![l6fader](https://forum-cdn.knime.com/user_avatar/forum.knime.com/l6fader/32/53149_2.png) [@l6fader](https://forum.knime.com/u/l6fader)\
**Post date:** [April 1, 2023, 5:24pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/19 "2023-04-01T17:24:44Z")

</div>

Just an FYI - i learned a trick from @sryu 's solution and updated my solution, since it was not part of the dataviz itself. It allowed me to remove ~10 nodes though so i wanted to say thank you!

---

<div class="post-metadata">

**Author:** ![lnunez02](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/ecccb3/32.png) [@lnunez02](https://forum.knime.com/u/lnunez02)\
**Post date:** [April 2, 2023, 1:35am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/20 "2023-04-02T01:35:04Z")

</div>

Aquí está mi solución para JKISeason2-1: [Comparing Exchange Rates](https://hub.knime.com/-/spaces/-/latest/~f3c8PxTkO7jhwhiP/)

Fue un reto muy interesante y entretenido, espero cumplir con la solución de todos los retos.

Este es mi primer post en el KNIME Hub.

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