Hello, experts. I have a question as shown in the image:
How can I change the negative values in the columns to 0?
I would like to automatically detect if a column contains negative values and set all negative values to 0.
To do that connect your table to a Math Formula (Multi Column) node.
Use this formula:
if($$CURRENT_COLUMN$$ <0,0 ,$$CURRENT_COLUMN$$ )
and check the box to replace selected columns:
Looks like this on simple input data:
Converted to this:
3 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.