Identifying Values in a column that sums up to ZERO

Hello Everyone,

I am quite new to Knime and I am trying to find a node that can help me identify ALL VALUES in a column that would sum up to zero. It contains negative and positive values. I found a solution online but doable in excel, I’d like to check if I can do it in Knime also. (see link below)

Does anyone knows what’s the best node I can use for this? thanks a lot! :slight_smile:

Hi @Ruru Welcome to KNIME Forum

Take a look at the Moving Aggregation node.

gr. Hans

1 Like

Hi Hans,

Thanks for answering.

But I’m afraid it did not work. :frowning: I am trying to identify all values that might equate to zero in one column. for example I have the column 1 below. I need a node that can identify the values (-5.1, 5.1 , 23 ,-23 ).

Colum 1

1 Like

Hi @Ruru

A sample input helps :grinning: See this sum_eq_zero.knwf (24.1 KB)
Screenshot from 2020-10-05 18-36-21
gr. Hans


OMG! You’re such a savior @HansS! It is now working! Thanks a lot!!! :clap: :raised_hands:


another solution here SUM 0.knwf (19.7 KB)
with the original list without values that sum to 0


1 Like

Glad I could help ! Happy KNIMEing

thanks for this @Luca_Italy! I’ll try this, too! :blush:

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