# 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:** 2

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

</div>

My submission for the JKI Season 2 Challenge -1.Bit tied on wkdays so challenged the sunday to start the new season. while Used the time series and python component while in built nodes are more then sufficient.

 ![Screenshot 2023-04-02 210536](https://forum-cdn.knime.com/uploads/default/original/3X/1/4/14b6152d6cd169ad52b7d1118044ee6c6c960179.jpeg)

> **[JKISeason2-1 – anilks](https://hub.knime.com/anilks/spaces/Just%20Knime%20It%20Challenges/latest/JustKnimeit-S2/JustKnimeit-S2C1~W5I6DoswPC8_8K4J)**
>
> JustKnimeit-S2C1

Anil

---

<div class="post-metadata">

**Author:** ![pranabjha](https://forum-cdn.knime.com/user_avatar/forum.knime.com/pranabjha/32/25362_2.png) [@pranabjha](https://forum.knime.com/u/pranabjha)\
**Post date:** [April 2, 2023, 5:52pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/22 "2023-04-02T17:52:21Z")

</div>

Hello All,  
This is my first post ever to the Just Knime It Challenges. (Although, I have been a Knime user for the last 2 years now). Happy to participate and see creative solutions from others as well. 😀  
Best,  
Pranab

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/5/857e278ca242a11cd9b281e669fa53158ffd7182.png)

Link to my hub page: [Comparing Exchange Rates – KNIME Community Hub](https://hub.knime.com/pranabjha/spaces/Public/latest/JKISeason2_1%20PNJ)

---

<div class="post-metadata">

**Author:** ![pranabjha](https://forum-cdn.knime.com/user_avatar/forum.knime.com/pranabjha/32/25362_2.png) [@pranabjha](https://forum.knime.com/u/pranabjha)\
**Post date:** [April 2, 2023, 5:53pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/23 "2023-04-02T17:53:52Z")

</div>

At first, I also thought of using Python. But then, I challenged myself to do without it. Succeeded… somewhat!  
Great plots, Anil.

---

<div class="post-metadata">

**Author:** ![arddashti](https://forum-cdn.knime.com/user_avatar/forum.knime.com/arddashti/32/34545_2.png) [@arddashti](https://forum.knime.com/u/arddashti)\
**Post date:** [April 3, 2023, 6:03am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/24 "2023-04-03T06:03:27Z")

</div>

Hello KNIMErs, Here is my solution for Challenge JKISeason2-1

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

#knime #JKISeason2-1 #dataanalysis #datascience

 ![1](https://forum-cdn.knime.com/uploads/default/original/3X/d/e/de6abda4e4a60fafd73b8f1a0054b6d790ebd23a.png)

---

<div class="post-metadata">

**Author:** ![ujlayan](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ujlayan/32/67980_2.png) [@ujlayan](https://forum.knime.com/u/ujlayan)\
**Post date:** [April 3, 2023, 6:55am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/25 "2023-04-03T06:55:35Z")

</div>

Here is my try to show correlation with respect to AUSTRUS-other currencies

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

---

<div class="post-metadata">

**Author:** ![HeatherPikairos](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/a88e4f/32.png) [@HeatherPikairos](https://forum.knime.com/u/HeatherPikairos)\
**Post date:** [April 3, 2023, 10:24am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/26 "2023-04-03T10:24:31Z")

</div>

Hi Everyone! My first post on the forum and what better way to do it than post my solution to Challenge 1!

My solution uses a -Single Selection Widget- node to decide whether to view the data as a Linear, Normalized or Logarithmic Line Plot with the -Line Plot (Labs)- node. The -Refresh Button Widget- node is used to update the data when choosing a different visualization:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/9/b/9bf3bf3a56de14ceb3b283c16ebfbd10d736bcab.jpeg)

I then use the -Linear Correlation- node and display the correlation matrix using the -Heat Map (Labs)- node:

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

The slider on the -Heat Map (Labs)- can be used to filter the matrix. For example, to display the most positively correlated currencies (Swiss Franc, Japanese Yen, Deutsche Mark and Dutch Guilder):

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

or the least correlated (for instance the Canadian Dollar and Deutsche Mark) :

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

The workflow is available from my HUB account at:

> **[20230403\_Pikairos\_JustKnimeIt\_Season2\_Challenge1\_ComparingExchangeRates –...](https://hub.knime.com/heatherpikairos/spaces/Public/latest/20230403_Pikairos_JustKnimeIt_Season2_Challenge1_ComparingExchangeRates~Ar2rJ--PrtGMj9Lb)**
>
> Challenge 01: Comparing Exchange Rates This workflow compares the daily exchange rates of US dollar vs 8 other currencies from 1980 to 1998. Linear interpolati…

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

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

Take a look and I hope you enjoy it!  
Heather

---

<div class="post-metadata">

**Author:** ![aworker](https://forum-cdn.knime.com/user_avatar/forum.knime.com/aworker/32/36421_2.png) [@aworker](https://forum.knime.com/u/aworker)\
**Post date:** [April 3, 2023, 12:48pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/27 "2023-04-03T12:48:01Z")

</div>

Congratulations Heather & welcome to the KNIME community forum !

Best  
Ael

---

<div class="post-metadata">

**Author:** ![niti.sethi](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/n/ce73a5/32.png) [@niti.sethi](https://forum.knime.com/u/niti.sethi)\
**Post date:** [April 3, 2023, 2:44pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/28 "2023-04-03T14:44:54Z")

</div>

Hi,I posted my solution,Waiting for solution tomorrow.

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

---

<div class="post-metadata">

**Author:** ![kwatari](https://forum-cdn.knime.com/user_avatar/forum.knime.com/kwatari/32/41003_2.png) [@kwatari](https://forum.knime.com/u/kwatari)\
**Post date:** [April 3, 2023, 3:20pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/29 "2023-04-03T15:20:27Z")

</div>

Here is my solution.

> **[JKI\_S2\_Challenge 01 Comparing Exchange Rates – kwatari](https://hub.knime.com/kwatari/spaces/Public/latest/JKIS2%20Challenge%2001%20Comparing%20Exchange%20Rates~MF7TqeOjWU3oDag7)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

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

---

<div class="post-metadata">

**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\
**Post date:** [April 3, 2023, 9:36pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/30 "2023-04-03T21:36:53Z")

</div>

Hello knimers,

Here it is my first contribution to the JKI\_S2’s challenges: [Just KNIME It S02 \_ CH01](https://hub.knime.com/search?type=all&tag=JKISeason2-1&sort=maxKudos)

Some features in my deployed solution are:

1. Statistical imputation based in week day differentials ( [component](https://hub.knime.com/-/spaces/-/latest/~UaRlHF__uRclf6EO/) )

2. Exchange rate tiles displaying Pearson’s and R^2 coefficients, for z-score normalized time series.

3. The dashboard can switch to display normalized values or normalized daily differentials.

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

> **[Just KNIME It S02 \_ CH01 \_ Comparing Exchange Rates – gonhaddock](https://hub.knime.com/gonhaddock/spaces/Just_KNIME_It/latest/Just%20KNIME%20It%20S02%20_%20CH01%20_%20Comparing%20Exchange%20Rates~5W6GjG30W0E6QVCx)**
>
> You are doing research on trading and different currencies and one of your tasks is to compare the daily exchange rates of US dollar vs 8 other currencies from…

BR

---

<div class="post-metadata">

**Author:** ![faber\_cst](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/f/90db22/32.png) [@faber\_cst](https://forum.knime.com/u/faber_cst)\
**Post date:** [April 3, 2023, 10:32pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/31 "2023-04-03T22:32:23Z")

</div>

Hello, Everybody!

My firts post ever in Knime Hub, since I’m using it just a few months…

As far as the challenge, I tried to keep the solution quite simple, and included the answers in the workflow…

> **[Just Knime It 2 - Challenge 01: Comparing Exchange Rates – faber\_cst](https://hub.knime.com/faber_cst/spaces/Public/latest/JustKnimeIt2%20-%20Challenge%2001~y23bXzk9cm3uofwh)**
>
> You are doing research on trading and different currencies and one of your tasks is to compare the daily exchange rates of US dollar vs 8 other currencies from…

Hope to see all of you in the next challenges… 😉

Regards  
Fabrício

---

<div class="post-metadata">

**Author:** ![egs](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/e47774/32.png) [@egs](https://forum.knime.com/u/egs)\
**Post date:** [April 4, 2023, 7:53am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/32 "2023-04-04T07:53:36Z")

</div>

my solution

> **[KNIME\_just2\_01 – egs](https://hub.knime.com/egs/spaces/Public/latest/KNIME_just2_01~um1eJKQXiz1DKUb3)**
>
> my solution

---

<div class="post-metadata">

**Author:** ![tomljh](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tomljh/32/67732_2.png) [@tomljh](https://forum.knime.com/u/tomljh)\
**Post date:** [April 4, 2023, 9:38am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/33 "2023-04-04T09:38:56Z")

</div>

[my solution](https://hub.knime.com/-/spaces/-/latest/~-wyZUwZR7B6j6O4V/)

---

<div class="post-metadata">

**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\
**Post date:** [April 4, 2023, 9:58am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/34 "2023-04-04T09:58:21Z")

</div>

@ujlayan , @egs, welcome to the KNIME forum!

Aiming to reflect on, that you have participated in the challenge; and to be considered for the **Just KNIME It! Leaderboard** as well:

“Remember to upload your solution with tag **JKISeason2-1** ( [link](https://hub.knime.com/search?type=all&tag=JKISeason2-1&sort=maxKudos) ) to your public space on the KNIME Community Hub.”

So, don’t forget to tag it!

BR

---

<div class="post-metadata">

**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\
**Post date:** [April 4, 2023, 9:59am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/35 "2023-04-04T09:59:40Z")

</div>

@niti.sethi , @arddashti , @lnunez02 , @elimisael

> [@gonhaddock](#):
>
> Aiming to reflect on, that you have participated in the challenge; and to be considered for the **Just KNIME It! Leaderboard** as well:
> 
> “Remember to upload your solution with tag **JKISeason2-1** ( [link](https://hub.knime.com/search?type=all&tag=JKISeason2-1&sort=maxKudos) ) to your public space on the KNIME Community Hub.”
> 
> So, don’t forget to tag it!

BR

P.S. a max of 5 mentions can be included in one post

---

<div class="post-metadata">

**Author:** ![DiaAzul](https://forum-cdn.knime.com/user_avatar/forum.knime.com/diaazul/32/48297_2.png) [@DiaAzul](https://forum.knime.com/u/DiaAzul)\
**Post date:** [April 4, 2023, 11:31am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/36 "2023-04-04T11:31:47Z")

</div>

Just for giggles, I gave the challenge a go - perhaps spent too much time on this 🤪

> **[ExchaneRateCorrelation – diaazul](https://hub.knime.com/diaazul/spaces/Public/Example%20Workflows/ExchaneRateCorrelation~HS_gcqm6WSK7lHDQ/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

Couple of notes:

1. The time period (1980-1998) covers the pre-Euro Exchange Rate Stability mechanism. Therefore, the Dutch Guilder, French France and Deutschmark should all be strongly correlated. There should also be periods in 1987 and 1991 when the British Pound was pegged to the Deutschmark and tracking the ERM which should also appear correlated - followed by periods of strong non-correlation.
2. The workflow I used has two phases. The first of which is to ETL the data: read the data, convert the string date field to Java DateTime, rebase the dataset to include all days between the earliest and latest dates (makes charts easier to read), and convert the columns to ISO Currency codes (makes it easier to understand what the data relates to-more user focused).
3. There are three mini-dashboard (more on those later). The first displays raw data; the other two show normalised data.
4. The first approach to normalisation is to index all values to a fixed data in time (1980-01-02). Therefore the indexed values are ratio change from the base data. This allows a correlation over the entire time period to be calculated.
5. The second approach is to normalise the data by calculating an index over a fixed time period (1, 7 or 28 days). This shows whether data is correlated over shorter time periods.
6. The dashboard is a KNIME component. I used custom Python components because (a) they are easier to format exactly as I want (b) I can theme the charts to my liking (c) it gives me a bit more practice.

## Workflow

 ![Screenshot 2023-04-04 121415](https://forum-cdn.knime.com/uploads/default/original/3X/8/7/87664e5af080c390715321c63b51aaff0f5fb79b.png)

## Normalisation by indexing to base year

 ![normalised_1980](https://forum-cdn.knime.com/uploads/default/original/3X/b/d/bdc770d13daeebc179c2f31e923dd58da317c016.png)

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

## Normalisation over 28 days

 ![normalised_28](https://forum-cdn.knime.com/uploads/default/original/3X/f/3/f3418f4a909227230567294cefc7ab1f0d0605c2.png)

It is possible using the Python Plotly components to zoom in on specific time periods, and to exclude traces to make chart clearer. The following is detail from the previous chart and shows how in 1982 the French Franc was having trouble maintaining correlation with the Dutch Guilder and Deutschmark.

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

Correlation plot (over the entire period, though should be possible to do correlations over short time periods).

 ![correlation_28](https://forum-cdn.knime.com/uploads/default/original/3X/5/d/5d0f9b8f11b7ff420df81c165f9a03f9412aa6c4.png)

DiaAzul  
[LinkedIn](https://www.linkedin.com/in/david-plummer-ab41791/) | [Medium](https://medium.com/@DiaAzul) | [GitHub](https://github.com/DiaAzul)

---

<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:** [April 4, 2023, 11:48am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/37 "2023-04-04T11:48:28Z")

</div>

> [@DiaAzul](#):
>
> - The time period (1980-1998) covers the pre-Euro Exchange Rate Stability mechanism. Therefore, the Dutch Guilder, French France and Deutschmark should all be strongly correlated. There should also be periods in 1987 and 1991 when the British Pound was pegged to the Deutschmark and tracking the ERM which should also appear correlated - followed by periods of strong non-correlation.

Nice background information! @DiaAzul Thanks!

---

<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:** [April 4, 2023, 1:59pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/38 "2023-04-04T13:59:09Z")

</div>

Hi folks,

Thank you so much for the incredible contributions! They were mindblowing! 🤯

We just posted our solution to KNIME Hub.

> **[Comparing exchange rates – knime](https://hub.knime.com/knime/spaces/Just%20KNIME%20It!/latest/Challenge%201%20-%20Comparing%20exchange%20rates%20-%20Solution~nWzGm9wYJrY3fhw3)**
>
> You are doing research on trading and different currencies and one of your tasks is to compare the daily exchange rates of US dollar vs 8 other currencies from…

We kept it simple, since understanding what currencies were the most correlated didn’t require too much effort. 😊 🤓 Still: so cool to see the composite visualizations that you folks came up with! Great practice for data apps!!

We hope to see you tomorrow for a new challenge! 💥 And **remember to tag your solutions with JKISeason2-X (where X is the number of the challenge) before uploading them to KNIME Hub**! This way they will count for our leaderboard. 🙂

---

<div class="post-metadata">

**Author:** ![MoLa\_Data](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mola_data/32/58742_2.png) [@MoLa\_Data](https://forum.knime.com/u/MoLa_Data)\
**Post date:** [April 4, 2023, 8:34pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/39 "2023-04-04T20:34:42Z")

</div>

late, but here is my solution! 😓

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/0/205acceeab18f6d6f937d508cb2b54ccafe5d07c.png)  
[JKISeason2-1 Ángel Molina.knwf](https://forum.knime.com/uploads/short-url/8MUMsryUfuHNDDwAQvivTOkt5mG.knwf) (577.6 KB)  
tomorrow, more and better! 💪

---

<div class="post-metadata">

**Author:** ![josedesouza](https://forum-cdn.knime.com/user_avatar/forum.knime.com/josedesouza/32/52377_2.png) [@josedesouza](https://forum.knime.com/u/josedesouza)\
**Post date:** [April 5, 2023, 3:20am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-01-season-2/64474/40 "2023-04-05T03:20:33Z")

</div>

Glad to join this wonderful community, from Ecuador: My submission

[[![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/a/ca4883aca6c719fdcb8c89550891ffe9587cf1a7.png)]](https://hub.knime.com/-/spaces/-/latest/~Fo7cK7UI4JxxvMlv/)

> **[JKISeason2-1 Comparing Exchange Rates Jose De Souza – josedesouza](https://hub.knime.com/josedesouza/spaces/Public/latest/JKISeason2-1%20Comparing%20Exchange%20Rates%20Jose%20De%20Souza~Fo7cK7UI4JxxvMlv)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

[JKISeason2-1 Comparing Exchange Rates Jose De Souza.knwf](https://forum.knime.com/uploads/short-url/47MR4yIvfz2fEjMu6yNke9eQHHs.knwf) (25.7 KB)

```auto

```

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

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