Finding and replacing NaN values in Number columns

[Leongwd]

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.

[mlauber71]

@Leongwd welcome to the KNIME forum

You might want to take a look at this example:

KNIME and Java - handle NaN (not a number) and Null - and Missing – mlauber71

[Leongwd]

Thanks @mlauber71 this was what I was looking for

[Daniel_Weikert]

[quote=“Leongwd, post:1, topic:37650”]
ce 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.

If you don’t know java you could use math formula multi column for converting NaN to ?
br

[ipazin]

Hello @Leongwd,

here is couple of more ides:

Nan to Missing Value

Hi, How can I change the Nan values of my data frame to missing values so I can use the missing value node? From the old forum https://www.knime.com/forum/knime-general/how-to-deal-with-nan-values, it says I should use a Java Snippet Row Filter to remove rows with NaN but I don’t want to remove them. I want to process it like how I do it with the Missing Value node. Thanks, Claudette

Br,
Ivan