Automatically Detect Negative Values in a Column and Replace Them with 0

[lca50666]

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.

[MartinDDDD]

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: