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

Resources Just KNIME It!
1

:boom: We’re finally back for the second season of our weekly Just KNIME It! challenges, folks! :boom:

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 :chart_with_upwards_trend:, correlation analysis, and data visualization :mag:.

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! :heart_eyes: Tell us all about it here .

Here is the challenge: Just KNIME It!

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

chart
chart930×979 12.4 KB

15 Likes
2

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

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
3

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

JNI - Challenge 01

4 Likes
4

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

6 Likes
5

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

3 Likes
6

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

image
image1705×875 203 KB

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

image
image1695×865 209 KB

8 Likes
7

Just use log view :smile: to see Correlations

image
image1543×952 118 KB

4 Likes
8

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
9

@sryu Well done! Very sophisticated.

2 Likes
10
3 Likes
11

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

image
image1023×882 96 KB

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
12

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
13

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

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

1 Like
15

@rfeigel
Thank you for your compliments.

1 Like
16

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

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

3 Likes
18

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
19

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
20

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