Hello, im an absolute rookie writing my thesis about the AI-based prediction of air filter failure. I am creating a batch of time series data with simulink. Currently each simulation run has 5 columns of variables, with the 5th being failure probability. I want to train a model with the runs 1-40, and validate it with runs 41-50. Each run is represented in a seperate sheet in a xlsx-file. Can someone push me in the right direction on how to handle the multiple time series, to do that? Edit: The data is cleaned, no missing values etc… I think i can figure out how to train a model, what im missing is how to handle the batch processing / extraction of multiple sheets.

Hi! And welcome Maybe this post can help you. [image] KNIME 4.+ Excel reader > read specific sheets but not all files have that sheet KNIME Analytics Platform Hi! I think there must be a simple solution but I came up with this. [image] 1º node you have to type the folder where you have the files. 2º node you choose the specific sheet name that you need. 3º node is for cleaning, to have just the “Path”. 4º node must have the Path. It creats the path in a loop, where you feed the excel reader with the created variable. 5º node: [image] [image] With the 6º node you finish the loop. The last one is to check if the workflow works correctly … Best of luck!

Analysing multiple time series sets

KNIME Analytics Platform

jorgemartcaam December 9, 2021, 10:48am 2

Hi! And welcome

Maybe this post can help you.

Best of luck!

2 Likes