I am trying to replace Error value 0 for Amount spend with the Mode) or remove them please suggest a node for me to do so.

[Nimisha1986]

Hello Everyone,

I am trying to replace Error value 0 for Amount spend with the Mode) or remove them please suggest a node for me to do so.

Please see below screenshot

[Nimisha1986]

My current data setup

[mlauber71]

@Nimisha1986 if you want to have the mode (the most frequent value of a column) you can use the advanced settings of the Missing Value node

[Nimisha1986]

yes i actually wanted to replace some of the values like 9999 to mode but how do i do it using missing value, i tried to figure out but was unable to

[mlauber71]

@Nimisha1986 you might first have to set the 9999 values to missing and then replace the missings

[Nimisha1986]

Sorry do you know hw do I set them to missing values?

[Nimisha1986]

I figured to use rule engine but i am unable to come out with the command (or rather get the correct one)
‘$Amount Spent$ = ‘9999’ => missing’ this si wrong… the column is amount spent and the number is 9999

[Nimisha1986]

I finally gotten the command to work but my amount spend became (?)

[mlauber71]

@Nimisha1986 here is a maybe slightly over-engineered version how to process multiple double values and replace a 9999.0 with NULL.

Replace specific values with Missings - multiple columns at once - KNIME Forum (76692).knwf (114.0 KB)

Replace specific values with Missings - multiple columns at once - KNIME...

[Nimisha1986]

Thanks, I manage to use two row filters to get it working.
Rule Filter #1 to identify 9999 values
$Amount Spent$ = 9999 => 9999
TRUE =>$Amount Spent$

Rule filter #2 Convert the values to missing
$Amount Spent$ < 9999 =>$Amount Spent$
MISSING $Amount Spent$ => FALSE