Filter rows in time series

KNIME Analytics Platform
1

Hello everyone.
I need some advice to solve the following problem.
In the attached table I would like to delete the rows highlighted in red.
The data is a time series that goes from day 295 to 302.
of day 302 I only need the first row relating to hour 0, I don’t need the other 22 rows.

Thank you for any answers.
SP
es1.xlsx (15.4 KB)

2

Hello @SANDROPELATI,

Zou can achieve this in multiple ways in KNIME. Asimple approach would be using a Rule-based Row Filter node and use the below expression.

$Day of Year$ <= 301  OR $H$  = 0 => TRUE

I have attached a sample workflow with the other approaches. Hope this helps.

Best,
Keerthan
KNIME_project.knwf (121.8 KB)

1 Like