Loop date&time

[Nutjaree_W]

I need to fiter EVENT_DATE row from 2021-06-25 06:00:00 to 2021-06-26 06:00:00 and automatical loop column at 2021-06-26 06:00:00 to 2021-06-27 06:00:00. Now I use Date&time-base row filter manual take date&time. How to filter date&time and loop all file?

[HansS]

Hi @Nutjaree_W welcome to KNIME Forum

I create this wf Loop date&time.knwf (28.5 KB). It adds an additional column to your table, that can be used to create segments of specific time range. You need to change the settings in Create Date&Time Range (to: 2021-06-25 06:00:00)

gr. Hans

[ipazin]

Hello @Nutjaree_W,

maybe looking for Window Loop Start node? Give it a try and if any questions/issues or we missunderstood you feel free to ask.

Welcome to Community!

Br,
Ivan