Hi, I was wondering if there was a way to find and replace NaN values with either a N/a or a 0 within a column similar to how one is able to find and replace missing values utilising the rule engine.

@Leongwd welcome to the KNIME forum You might want to take a look at this example: [image] KNIME and Java - handle NaN (not a number) and Null - and Missing – mlauber71 KNIME and Java - handle NaN (not a number) and Null - and Missing

Finding and replacing NaN values in Number columns

KNIME Analytics Platform

ipazin November 29, 2021, 10:13pm 5

Hello @Leongwd,

here is couple of more ides:

Br,
Ivan

1 Like