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

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

Feel free to link your solution from KNIME Community Hub 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 .

Here is the challenge: Just KNIME It!

Feel free to link your solution from KNIME Hub as well!

15 Likes

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

9 Likes

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

JNI - Challenge 01

4 Likes

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

6 Likes

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

3 Likes

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

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

8 Likes

Just use log view to see Correlations

4 Likes

Hello Knimers,

here’s my solution to the challenge:

• 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

5 Likes

@sryu Well done! Very sophisticated.

2 Likes
3 Likes

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

The flow is on the following URL JKISeason2-1 – KNIME Community Hub

• 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
7 Likes

For some users who can speak Chinese, check out my video on youtube. 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.

2 Likes

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

2 Likes

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

1 Like

@rfeigel
Thank you for your compliments.

1 Like

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

2 Likes

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

3 Likes

Here is my solution for JKISeason2-1: Challenge 01_Comparing Exchange Rates_LDF

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.

2 Likes

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!

3 Likes

Aquí está mi solución para JKISeason2-1: Comparing Exchange Rates

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.

2 Likes