# \#time-series **URL:** https://forum.knime.com/tag/time-series/115.md [Latest](https://forum.knime.com/latest.md) · [Categories](https://forum.knime.com/categories.md) · [Tags](https://forum.knime.com/tags.md) --- ## [Read time from Excel sheet as it is shown in Excel](https://forum.knime.com/t/read-time-from-excel-sheet-as-it-is-shown-in-excel/91091)
**Author:** [@rolandw](https://forum.knime.com/u/rolandw)\ **Replies:** 2\ **Last updated:** [December 28, 2025, 8:50am UTC](https://forum.knime.com/t/read-time-from-excel-sheet-as-it-is-shown-in-excel/91091 "2025-12-28T08:50:00Z")
Hey KNIME friends, I hope everyone had some happy holidays and a couple of days off before the new year starts :slight\_smile: I am working on a process simulation workflow that shall give me the desired metrics conveni… --- ## [SARIMA Labs (Node) workflow not able to execute properly on KNIME Business Hub](https://forum.knime.com/t/sarima-labs-node-workflow-not-able-to-execute-properly-on-knime-business-hub/90679)
**Author:** [@Umesh\_0624](https://forum.knime.com/u/Umesh_0624)\ **Replies:** 4\ **Last updated:** [December 2, 2025, 6:51am UTC](https://forum.knime.com/t/sarima-labs-node-workflow-not-able-to-execute-properly-on-knime-business-hub/90679 "2025-12-02T06:51:23Z")
Hey folks, I’m building SARIMA model for forecasting, while running on KNIME Analytics Platform it is taking 2 - 3 mins to execute. But same workflow deployed on KNIME Business Hub, it is taking more than 10 mins & ofte… --- ## [Codeless Time Series Analysis with KNIME Book](https://forum.knime.com/t/codeless-time-series-analysis-with-knime-book/90829)
**Author:** [@Prosper98](https://forum.knime.com/u/Prosper98)\ **Replies:** 1\ **Last updated:** [November 27, 2025, 11:13pm UTC](https://forum.knime.com/t/codeless-time-series-analysis-with-knime-book/90829 "2025-11-27T23:13:13Z")
Can someone share with this book or suggest me a free good course to master Time Series Analysis with Knime. I don’t have enough money to buy it. I want to learn its content and integrate Time series analysis of environm… --- ## [Multivariate Multi-step Time Series LSTM Model](https://forum.knime.com/t/multivariate-multi-step-time-series-lstm-model/86169)
**Author:** [@CarlosEnrique84](https://forum.knime.com/u/CarlosEnrique84)\ **Replies:** 5\ **Last updated:** [March 18, 2025, 9:39pm UTC](https://forum.knime.com/t/multivariate-multi-step-time-series-lstm-model/86169 "2025-03-18T21:39:01Z")
Hi, I want to know how to configure a LSTM time series model to forecast multi-steps ahead instead of a single-step. @tim\_19801 I read your post about a similar question in 2023. Have you found the solution? This is t… --- ## [Sales Forecasting AutoML (Regression)](https://forum.knime.com/t/sales-forecasting-automl-regression/86445)
**Author:** [@clp\_aust](https://forum.knime.com/u/clp_aust)\ **Replies:** 1\ **Last updated:** [March 5, 2025, 9:56pm UTC](https://forum.knime.com/t/sales-forecasting-automl-regression/86445 "2025-03-05T21:56:29Z")
Hello, I am a beginner with Knime. After I was able to use AutoML for classification without major problems, I wanted to use AutoML (regression) to predict sales up to 31 December 2025. Principally the workflow works,… --- ## [The Lead Column Component](https://forum.knime.com/t/the-lead-column-component/86611)
**Author:** [@CarlosEnrique84](https://forum.knime.com/u/CarlosEnrique84)\ **Replies:** 7\ **Last updated:** [February 23, 2025, 4:28pm UTC](https://forum.knime.com/t/the-lead-column-component/86611 "2025-02-23T16:28:40Z")
Hi everyone, I’m excited to introduce the Lead Column component, which performs the reverse task of the Lag Column node. While the Lag Column node generates a lag of a column, the Lead Column component generates a lead,… --- ## [How to define a DATE column as primary key in a time-series data?](https://forum.knime.com/t/how-to-define-a-date-column-as-primary-key-in-a-time-series-data/84737)
**Author:** [@dataHoarder](https://forum.knime.com/u/dataHoarder)\ **Replies:** 47\ **Last updated:** [December 6, 2024, 9:28am UTC](https://forum.knime.com/t/how-to-define-a-date-column-as-primary-key-in-a-time-series-data/84737 "2024-12-06T09:28:41Z")
I need to define a primary key in a time-series dataset. I have tried this setup with the “DB Table Creator” node (the last end of the workflow shown here): The settings in the DB Table Creator node: But still,… --- ## [fbprophet component add table output](https://forum.knime.com/t/fbprophet-component-add-table-output/84811)
**Author:** [@rfeigel](https://forum.knime.com/u/rfeigel)\ **Replies:** 1\ **Last updated:** [November 19, 2024, 4:54pm UTC](https://forum.knime.com/t/fbprophet-component-add-table-output/84811 "2024-11-19T16:54:49Z")
@roberto\_cadili I’ve added tabular output to the original fbprophet component. Hope its useful for many users. See below for the necessary modifications. --- ## [How to calculate the seasonal performance of an index?](https://forum.knime.com/t/how-to-calculate-the-seasonal-performance-of-an-index/83231)
**Author:** [@tone\_n\_tune](https://forum.knime.com/u/tone_n_tune)\ **Replies:** 16\ **Last updated:** [November 17, 2024, 3:52pm UTC](https://forum.knime.com/t/how-to-calculate-the-seasonal-performance-of-an-index/83231 "2024-11-17T15:52:49Z")
Hi All, I have been looking to reproduce this seasonality chart of S&P500 Index but for NASDAQ100 Index - Imgur: The magic of the Internet I request help in calculating the seasonal performance (%) of the index, somethi… --- ## [Help with Time Series Data Windowing Based on Target Columns in KNIME](https://forum.knime.com/t/help-with-time-series-data-windowing-based-on-target-columns-in-knime/81833)
**Author:** [@Mohammad\_Khasaw](https://forum.knime.com/u/Mohammad_Khasaw)\ **Replies:** 1\ **Last updated:** [August 8, 2024, 1:19am UTC](https://forum.knime.com/t/help-with-time-series-data-windowing-based-on-target-columns-in-knime/81833 "2024-08-08T01:19:25Z")
Hi everyone, I am working with a time series dataset in KNIME that includes stock prices and various indicators (indicator1, indicator2, etc.). Each row in my dataset represents a different indicator and one time step (… --- ## [Issues with ARIMA-Learner Node](https://forum.knime.com/t/issues-with-arima-learner-node/81837)
**Author:** [@JakobJosef](https://forum.knime.com/u/JakobJosef)\ **Replies:** 7\ **Last updated:** [August 6, 2024, 9:10am UTC](https://forum.knime.com/t/issues-with-arima-learner-node/81837 "2024-08-06T09:10:51Z")
Dear community, I m having issues with the ARIMA-Learner-Node. I would like to create a predictive forecast for sales of hardware, for the next 12 months. I tried using ARIMA-nodes, but I get strange results. Especiall… --- ## [Time Series Forecasting with fbProphet](https://forum.knime.com/t/time-series-forecasting-with-fbprophet/80765)
**Author:** [@roberto\_cadili](https://forum.knime.com/u/roberto_cadili)\ **Replies:** 7\ **Last updated:** [July 12, 2024, 11:30pm UTC](https://forum.knime.com/t/time-series-forecasting-with-fbprophet/80765 "2024-07-12T23:30:58Z")
\#Timeseries analysis involves examining data at specific times to identify trends and patterns. @deganza develops a #lowcode solution with #KNIME to #forecast #airline passengers and the #weather using the #Facebook #Pro… --- ## [Online Course: \[L4-TS\] Introduction to Time Series Analysis](https://forum.knime.com/t/online-course-l4-ts-introduction-to-time-series-analysis/25327)
**Author:** [@Maarit](https://forum.knime.com/u/Maarit)\ **Replies:** 23\ **Last updated:** [May 21, 2024, 4:16pm UTC](https://forum.knime.com/t/online-course-l4-ts-introduction-to-time-series-analysis/25327 "2024-05-21T16:16:41Z")
Course Focus This course introduces the main concepts behind Time Series Analysis, with an emphasis on forecasting applications: data cleaning, missing value imputation, time-based aggregation techniques, creation of a … --- ## [Example Workflows of Supervised Machine Learning on Time-series data?](https://forum.knime.com/t/example-workflows-of-supervised-machine-learning-on-time-series-data/78227)
**Author:** [@tone\_n\_tune](https://forum.knime.com/u/tone_n_tune)\ **Replies:** 3\ **Last updated:** [April 1, 2024, 2:31am UTC](https://forum.knime.com/t/example-workflows-of-supervised-machine-learning-on-time-series-data/78227 "2024-04-01T02:31:49Z")
Hi All, I intend to use XGBoost on Time-series data. It appears that Time-series data needs to be made suitable for Supervised ML first by doing feature engineering. As such, I need some example workflows on Time-series … --- ## [L4-TS: Time Series Analysis in KNIME Analytics Platform](https://forum.knime.com/t/l4-ts-time-series-analysis-in-knime-analytics-platform/76415)
**Author:** [@arief\_rama](https://forum.knime.com/u/arief_rama)\ **Replies:** 15\ **Last updated:** [February 6, 2024, 3:29pm UTC](https://forum.knime.com/t/l4-ts-time-series-analysis-in-knime-analytics-platform/76415 "2024-02-06T15:29:38Z")
I currently have plans to obtain the L4-TS: Time Series Analysis certification in the KNIME Analytics Platform, but when I checked on KNIME, I couldn’t find the L4-TS materials. Is the content being updated or replaced?… --- ## [Intro to Time Series Analysis](https://forum.knime.com/t/intro-to-time-series-analysis/75017)
**Author:** [@roberto\_cadili](https://forum.knime.com/u/roberto_cadili)\ **Replies:** 2\ **Last updated:** [November 10, 2023, 1:39pm UTC](https://forum.knime.com/t/intro-to-time-series-analysis/75017 "2023-11-10T13:39:23Z")
In #timeseries #analysis the temporal structure of the data means that important assumptions about the consistency of observations must be specifically addressed. @deganza provides an intro to the basics of times series … --- ## [SARIMA Uploaded with errors - on K.AP 5.1.1 (but on 4.7.7 it works... why?)](https://forum.knime.com/t/sarima-uploaded-with-errors-on-k-ap-5-1-1-but-on-4-7-7-it-works-why/74850)
**Author:** [@PVergati](https://forum.knime.com/u/PVergati)\ **Replies:** 12\ **Last updated:** [November 3, 2023, 3:17pm UTC](https://forum.knime.com/t/sarima-uploaded-with-errors-on-k-ap-5-1-1-but-on-4-7-7-it-works-why/74850 "2023-11-03T15:17:03Z")
Good morning everybody. attached (SARIMA learner node and some troubles about some packages impossibile to install). As you can see this is a list of issues I’m facing since some days ago: error uploading SARIMA Lear… --- ## [Updates requested in SARIMA Learner and Predictor components](https://forum.knime.com/t/updates-requested-in-sarima-learner-and-predictor-components/72748)
**Author:** [@nilotpalc](https://forum.knime.com/u/nilotpalc)\ **Replies:** 2\ **Last updated:** [September 20, 2023, 4:51am UTC](https://forum.knime.com/t/updates-requested-in-sarima-learner-and-predictor-components/72748 "2023-09-20T04:51:58Z")
Hello, I was trying to use the SARIMA Learner and Predictor nodes. I was getting the below mentioned errors. “Unable to import datetime from pandas” I checked the error message on ChatGPT and understand that the code… --- ## [Insample forecast of Auto-SARIMA very good, forecast of SARIMA Learner/Predictor with Auto-SARIMA hyperparameters poor](https://forum.knime.com/t/insample-forecast-of-auto-sarima-very-good-forecast-of-sarima-learner-predictor-with-auto-sarima-hyperparameters-poor/72599)
**Author:** [@Christian\_Essen](https://forum.knime.com/u/Christian_Essen)\ **Replies:** 0\ **Last updated:** [September 13, 2023, 2:58pm UTC](https://forum.knime.com/t/insample-forecast-of-auto-sarima-very-good-forecast-of-sarima-learner-predictor-with-auto-sarima-hyperparameters-poor/72599 "2023-09-13T14:58:55Z")
Hello KNIMERs, As you can read in the title, I have a time series on energy consumption in hours with two seasonalities: 24 and 168. If I run Auto-SARIMA with the first 500 values, I get a very good quality insample for… --- ## [Round up time values](https://forum.knime.com/t/round-up-time-values/71953)
**Author:** [@IMR2KA](https://forum.knime.com/u/IMR2KA)\ **Replies:** 3\ **Last updated:** [August 23, 2023, 3:55pm UTC](https://forum.knime.com/t/round-up-time-values/71953 "2023-08-23T15:55:51Z")
Hello all, I want to round the column with time data type to the closest 15 minutes of an hour to the bigger side(please see the table). Time Rounded time column 5:03:15 5:15:00 5:09:12 5:15:00 5:21:33 5:30… --- ## [How to keep the full output of and ARIMA model node?](https://forum.knime.com/t/how-to-keep-the-full-output-of-and-arima-model-node/71855)
**Author:** [@mahmoudamintaha](https://forum.knime.com/u/mahmoudamintaha)\ **Replies:** 1\ **Last updated:** [August 21, 2023, 9:27am UTC](https://forum.knime.com/t/how-to-keep-the-full-output-of-and-arima-model-node/71855 "2023-08-21T09:27:13Z")
in this part of my workflow, I have this table up to 2013: the table has the year and 332 cities And I want to predict more than ten years up to 2022 the problem is that the output of the Arima model is only one c… --- ## [Request revenue prediction](https://forum.knime.com/t/request-revenue-prediction/68765)
**Author:** [@Dfallas27](https://forum.knime.com/u/Dfallas27)\ **Replies:** 1\ **Last updated:** [June 13, 2023, 2:05pm UTC](https://forum.knime.com/t/request-revenue-prediction/68765 "2023-06-13T14:05:20Z")
Hello community, how can I predict the income of requests in an entity? I have the number of requests that entered in 5 years, on a monthly basis. Is it necessary to apply a time series analysis? Any flow that works for … --- ## [WhatsApp Group Chat Analysis (Influencer and dependents)](https://forum.knime.com/t/whatsapp-group-chat-analysis-influencer-and-dependents/68515)
**Author:** [@hakandurgut](https://forum.knime.com/u/hakandurgut)\ **Replies:** 2\ **Last updated:** [June 6, 2023, 1:23pm UTC](https://forum.knime.com/t/whatsapp-group-chat-analysis-influencer-and-dependents/68515 "2023-06-06T13:23:46Z")
Hi, I have exported a WhatsApp Group Chat, there are 7 participants in this WhatsApp group. Over a span of 218 days, a total of 7 individuals engaged in a lively conversation, resulting in a count of 3,719 chat messages… --- ## [Getting time periods from consecutive timestamps and activities per user](https://forum.knime.com/t/getting-time-periods-from-consecutive-timestamps-and-activities-per-user/66803)
**Author:** [@svki0001](https://forum.knime.com/u/svki0001)\ **Replies:** 4\ **Last updated:** [May 12, 2023, 3:48pm UTC](https://forum.knime.com/t/getting-time-periods-from-consecutive-timestamps-and-activities-per-user/66803 "2023-05-12T15:48:26Z")
uid activity timestamp 123 Activity1 1370520169521 123 Activity1 1370520279532 123 Activity2 1370520319543 123 Activity2 1370520419554 123 Activity2 1370520569565 123 Activity1 1370520679576 123 Activity1 1370520779587 1… --- ## [Codeless Time Series Analysis](https://forum.knime.com/t/codeless-time-series-analysis/66194)
**Author:** [@elisrich](https://forum.knime.com/u/elisrich)\ **Replies:** 3\ **Last updated:** [May 1, 2023, 4:14pm UTC](https://forum.knime.com/t/codeless-time-series-analysis/66194 "2023-05-01T16:14:32Z")
Do you know what it means when a time series is weakly stationary? Check out this short video from our Data Science Pronto series where @alinebessa answers this question :arrow\_right: Data Science Pronto! - Weak Statio… --- ## [Multivariate Time Series Analysis – Predict Multiple Periods Ahead](https://forum.knime.com/t/multivariate-time-series-analysis-predict-multiple-periods-ahead/62507)
**Author:** [@tim\_19801](https://forum.knime.com/u/tim_19801)\ **Replies:** 1\ **Last updated:** [February 24, 2023, 5:43pm UTC](https://forum.knime.com/t/multivariate-time-series-analysis-predict-multiple-periods-ahead/62507 "2023-02-24T17:43:53Z")
I have spent the past few 20 months looking into different software to help me predict the opening daily stock price into the future. All software has the ability to rank/score testing data against actual data using mult… --- ## [Generate next day](https://forum.knime.com/t/generate-next-day/60805)
**Author:** [@sebastian911](https://forum.knime.com/u/sebastian911)\ **Replies:** 1\ **Last updated:** [January 31, 2023, 4:11pm UTC](https://forum.knime.com/t/generate-next-day/60805 "2023-01-31T16:11:58Z")
HI, I want to generate a new column with next day from existing one. How can i do it? EX: First Column New Column Difference 1.01.2023 2.01.2023 … --- ## [Problems with SARIMA and ARIMA](https://forum.knime.com/t/problems-with-sarima-and-arima/60281)
**Author:** [@stefano\_c](https://forum.knime.com/u/stefano_c)\ **Replies:** 0\ **Last updated:** [January 24, 2023, 3:05pm UTC](https://forum.knime.com/t/problems-with-sarima-and-arima/60281 "2023-01-24T15:05:46Z")
Hi everybody, I have three problems after the new ARIMA and SARIMA model updates: I can’t use the AUTO-SARIMA node correctly and I don’t understand if it requires a detrended and seasonally adjusted time series (“Res… --- ## [AutoSarima](https://forum.knime.com/t/autosarima/59292)
**Author:** [@veniapputrii](https://forum.knime.com/u/veniapputrii)\ **Replies:** 4\ **Last updated:** [January 13, 2023, 9:55am UTC](https://forum.knime.com/t/autosarima/59292 "2023-01-13T09:55:53Z")
Hello! I’ve tried to do a time series analysis using AutoSarima Node. I use a dataset with a span of 1 year back to predict its movement in the next 3 days. But, I have a problem, namely, the AutoSarima Node cannot pre… --- ## [Recompose signal in time series componentes](https://forum.knime.com/t/recompose-signal-in-time-series-componentes/56491)
**Author:** [@hrecinos](https://forum.knime.com/u/hrecinos)\ **Replies:** 1\ **Last updated:** [December 20, 2022, 8:25am UTC](https://forum.knime.com/t/recompose-signal-in-time-series-componentes/56491 "2022-12-20T08:25:57Z")
Hello folks, I am using time series componentes to forecast an horizon of 4 weeks of income. The Remove Seasonality Componente outputs the removed seasonality column and used differencing to calculate it. The ARIMA Pred… [Next page](https://forum.knime.com/tag/time-series/115.md?match_all_tags=true&page=1&tags%5B%5D=time-series)