Identifying Values in a column that sums up to ZERO

[Ruru]

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!

Find positive and negative amounts that net to zero

[HansS]

Hi @Ruru Welcome to KNIME Forum

Take a look at the Moving Aggregation node.

.
gr. Hans

[Ruru]

@HansS

gr. Ha

Hi Hans,

Thanks for answering.

But I’m afraid it did not work. 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
2
-1
-5.1
5.1
24.2
23.1
-23
23
-23.7

[HansS]

Hi @Ruru

A sample input helps See this sum_eq_zero.knwf (24.1 KB)

gr. Hans

[Ruru]

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

[Luca_Italy]

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

Luca

[HansS]

Glad I could help ! Happy KNIMEing

[Ruru]

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