# Solutions to "Just KNIME It!" Challenge 36 **URL:** \ **Category:** Just KNIME It!\ **Tags:** justknimeit\ **Created:** [September 28, 2022, 1:31pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658 "2022-09-28T13:31:43Z")\ **Posts on this page:** 15\ **Page:** 1
**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:** [September 28, 2022, 1:31pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/1 "2022-09-28T13:31:43Z")
This thread is for posting solutions to “Just KNIME It!” Challenge 36. This week we’ll be working with time series data to celebrate our [new book on the subject](https://www.knime.com/codeless-time-series-analysis-with-knime)! 😉 ☺ 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! 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). Season 1 of “Just KNIME It!” is slowly coming to an end: we’ll wrap up on October 26! ---
**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:** [September 28, 2022, 4:30pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/2 "2022-09-28T16:30:48Z")
Hello everyone, here is my solution for the challenge: > **[justknimeit - 36 - Raffaello Barri – lelloba](https://hub.knime.com/lelloba/spaces/Public/latest/Just%20Knime%20it!/justknimeit%20-%2036%20-%20Raffaello%20Barri~o-EeqCKAjPC7ED1L)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. Firstly, using the timestamp alignment node, I created all missing timestamps. Secondly, I used a column expression node to understand the day name; a rule-based filter deletes weekends. Have a nice evening, Raffaello ---
**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:** [September 28, 2022, 5:52pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/3 "2022-09-28T17:52:13Z")
Here’s my solution > **[REF Challenge 36 – rfeigel](https://hub.knime.com/rfeigel/spaces/Public/latest/REF%20Challenge%2036~WQf88ymqzO-GdohX)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. ![REF Challenge 36 jpg](https://forum-cdn.knime.com/uploads/default/original/3X/e/4/e4f188f35ccac34df8d22e0854a732071b2ba956.jpeg) ---
**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:** [September 28, 2022, 6:07pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/4 "2022-09-28T18:07:17Z")
My take on the time series data prep challenge … quite relevant and frequent observed issue for time series probs. > **[Just knime it -036 – anilks](https://hub.knime.com/anilks/spaces/Just%20Knime%20It%20Challenges/latest/Just%20Knime%20It%20Challenge/Just%20knime%20it%20-036~XFqM_Ste7N4vgibV)** > > Just Knime it -036 ![ch36](https://forum-cdn.knime.com/uploads/default/original/3X/5/7/5712c43d265f71e263ce4bf12bc5d2b65d72b75d.png) ![flow](https://forum-cdn.knime.com/uploads/default/original/3X/f/d/fd9c38d59371caaf2e99912b46ddac761baf3c75.png) ---
**Author:** ![Andrew\_Steel](https://forum-cdn.knime.com/user_avatar/forum.knime.com/andrew_steel/32/4472_2.png) [@Andrew\_Steel](https://forum.knime.com/u/Andrew_Steel)\ **Post date:** [September 28, 2022, 7:32pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/5 "2022-09-28T19:32:47Z")
Hi Knimers, here is my solution: > **[Implementing Custom Time Alignment – andrew\_steel](https://hub.knime.com/andrew_steel/spaces/Public/latest/ImplementingCustomTimeAlignment~yvJkmTnoFH-Ro5IY)** > > Description: KNIME has just released a new textbook on time series: to celebrate it, we will do a little time series analysis in this challenge. Check out the … ![Bildschirmfoto vom 2022-09-28 21-27-50](https://forum-cdn.knime.com/uploads/default/original/3X/2/b/2bc9b3306de9ace7c0316f20ca0a23582869ceeb.png) Best regrads Andrew ---
**Author:** ![ndwulst](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/n/9de0a6/32.png) [@ndwulst](https://forum.knime.com/u/ndwulst)\ **Post date:** [September 28, 2022, 10:38pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/6 "2022-09-28T22:38:21Z")
Hello everyone, Here is my attempt at this challenge: > **[justknimeit-36 - Implementing Custom Time Alignment – ndwulst](https://hub.knime.com/ndwulst/spaces/Just%20KNIME%20It!%20Challenge/latest/justknimeit-36%20-%20Implementing%20Custom%20Time%20Alignment~pXemZbJ4V368Zurl)** > > Challenge 36 - Implementing Custom Time Alignment Level - Medium Description - KNIME has just released a new textbook on time series to celebrate it, we will d… Regards, ---
**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:** [September 28, 2022, 11:09pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/7 "2022-09-28T23:09:46Z")
Added a line plot to my workflow. ---
**Author:** ![eamendola](https://forum-cdn.knime.com/user_avatar/forum.knime.com/eamendola/32/36540_2.png) [@eamendola](https://forum.knime.com/u/eamendola)\ **Post date:** [September 30, 2022, 12:14am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/8 "2022-09-30T00:14:09Z")
Hi guys ! My approach on this challenge ! > **[Challenge 36 - Implementing Custom Time Alignment – eamendola](https://hub.knime.com/eamendola/spaces/Just%20KNIME%20it%20!/latest/Challenge%2036%20-%20Implementing%20Custom%20Time%20Alignment~OwuZa37zwwM1zjhf)** > > Introduce the missing timestamps that correspond to weekdays into the given data, while omitting those for weekends ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/2/0264574f7f74bb1a95d065dc26f4c7f56aa87c70.png) ---
**Author:** ![ersy](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/71c47a/32.png) [@ersy](https://forum.knime.com/u/ersy)\ **Post date:** [October 1, 2022, 10:52am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/9 "2022-10-01T10:52:41Z")
Hi everyone, Here is my solution. I used [Timestamp Alignment](https://hub.knime.com/knime/spaces/Examples/latest/00_Components/Time%20Series/Timestamp%20Alignment~lTj0tRRU1w6R6JEd) node from Hub. > **[justKnimeit-36 – ersy](https://hub.knime.com/ersy/spaces/Public/latest/justKnimeit-36~A2pomNOFumc17J7p)** > > Challenge 36: Implementing Custom Time Alignment ---
**Author:** ![cf\_123](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/c/a88e57/32.png) [@cf\_123](https://forum.knime.com/u/cf_123)\ **Post date:** [October 1, 2022, 1:14pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/10 "2022-10-01T13:14:24Z")
Hi, here my solution: [jKi-36 – KNIME Hub](https://hub.knime.com/cf_123/spaces/Public/latest/jKi-36) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/e/0eee107da64f8b1aa3127952ea402cd9fd9b861e.png) ---
**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:** [October 2, 2022, 1:43pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/11 "2022-10-02T13:43:26Z")
Hi everyone, this is my solution. > **[Challenge 36 Implementing Custom Time Alignment – kwatari](https://hub.knime.com/kwatari/spaces/Public/latest/Challenge%2036%20Implementing%20Custom%20Time%20Alignment~8H36RkGTb3A4uror)** > > It was my first time to use the Timestamp Alignment component. Good to know it. ---
**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:** [October 4, 2022, 1:42pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/12 "2022-10-04T13:42:03Z")
Hi folks! 🙂 As always on Tuesdays, here’s our solution to last week’s challenge! > **[Challenge 36 - Implementing Custom Time Alignment - Solution – alinebessa](https://hub.knime.com/knime/spaces/Just%20KNIME%20It!/latest/Challenge%2036%20-%20Implementing%20custom%20time%20alignment~UqlrHGTJWaUUAnih)** > > KNIME has just released a new textbook on time series: to celebrate it, we will do a little time series analysis in this challenge. Check out the book (and dis… Short and sweet, right? 😊 We hope you learned something new about time series with this challenge! 💥 See you tomorrow for a new one! 💥 ---
**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:** [October 5, 2022, 11:37am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/13 "2022-10-05T11:37:22Z")
Hello KNIMErs, Here is my solution to **[#justknimeit-36](https://hub.knime.com/search?type=all&tag=justknimeit-36&sort=maxKudos)** : KNIME Hub \> gonhaddock \> Spaces \> Just\_KNIME\_It \> **[Just KNIME It \_ Challenge 036](https://kni.me/w/FVq1_Z-cFYh6iS_3)** With a bonus task component included; statistical imputation based on daily differentials: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/8/48b36d5128f2455eeeda900f3e4115073b2abcfe.jpeg) BR ---
**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:** [October 5, 2022, 12:39pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/14 "2022-10-05T12:39:08Z")
Oh wow! That’s fancy! 😃 Thanks for this solution! ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [January 3, 2023, 12:40pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-36/47658/15 "2023-01-03T12:40:07Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.