How to sum rows only if a data is between a range

KNIME Analytics Platform
#1

Hi!
I have an excel with ID and relative dates.
I need to count the total of ID if a Date is between a range…How can I do that?

Thanks
Giada

#2

I need to count the total of ID

This is unclear. Do you need a count? Or do you need a sum?

Off the top of my head, I’d suggest using a Row Filter node to isolate the relevant rows, and then a Group By node to aggregate the appropriate column.

4 Likes
#3

I need a count of ID (field ID) if the data (field DATE) is between a range (for example between 2016 and 2017…
I have used the node “Date&Time - based Row filter”…But I want to add a condition for example:
between 2017 and 2016 OR 2018 and 2019

How can I do that?
Thanks
Giada

#4

Hi @giad
If you first convert the dates (those on which the filter is based) into flow variables, you can use the “Rule Engine” to write your desired conditions.
image

4 Likes
#5

Hello @giad,

see this workflow example:

Br,
Ivan

4 Likes
#6

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.