Delete a machine resting period time window from table

hi @Vaamen
i’m not an expert at explaining things, especially in english. :smiling_face_with_tear:

referring to my previous post since don’t have any real data, i just created dummy data to illustrate how the filter works. extracted and split the data using three nodes before the filter node. the required nodes depend on how your raw data is presented.

to answer to your recent question:

  • if your data pattern for machine shutdown during lunch break always occurs between 11:50 am and 13:10 pm, you can set rules to:
    $YourDate&TimeColumns$ >= “11:50” AND $YourDate&TimeColumns$ <= “13:10” => TRUE
  • b. but if your data already states the “lunch break” in the description, it becomes easier: you can just filter through patterns.
    ${YourDate&TimeDescription} LIKE “lunch break” => TRUE
  • c. to filter out days such as sunday, saturday, etc., you must mention either the date or the name of the days in the raw data.

I’ve attached a sample workflow for you to explore and start with.
KNIME_time-windw-MM.knwf (142.6 KB)

If you’re using version 5.1, you can get a detailed explanation of any node by clicking the description tab on the left of the panel.
If you need more information about KNIME nodes, this forum link may be a helpful starting point:

rgds
linux knime 5.1.x

2 Likes