replace zero with Null or missing values

KNIME Analytics Platform
1

Hi, how do I replace zero with missing values or blank and apply the logic to 100+ columns?

2

You can use node String Manipulation with condition like this:
image

2 Likes
3

I could think of math multicolumn node with formula

$$CURRENT_COLUMN$$/$$CURRENT_COLUMN$$ *$$CURRENT_COLUMN$$

br

2 Likes
4

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