If it is not first format your data as time (String to DateTime node) then extract only the hours (Rxtract DateTime Fields node). At the end use GroupBy node
I like the solution posed by @andrejz, you can also use regex to extract the first digit from each of your times and then use groupby using a summation aggregation.
hi,
My client is using the older version of KNIME (3.7.1) and havenβt got permission to upgrade. I am unable to use column Expression Node - JavaScript Regex.
Also I am able to do the above solution mentioned by @andrez.
But do I need to use the loop to get the counts for the hours 6AM to 8PM or is there any better logic to work with.
If you want to group data (hours) in a range (for example 0-3, 4-7,β¦) you can use Auto Binner or Numeric Binner node to create this ranges.
This can also be done with the Rule engine node (in this case you can divide the day in night, morning afternoon,β¦)
@andrejz : Thanks a lot for your great help.
As I am new to Knime I am struggling lot to find the nodes.
PFA screenshot of my model. Your timely help is appreciable.
I donβt have permission to install python in the remote desktop. but i will try the python option in my personal machine.