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!
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 ).