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.

KNIME Analytics Platform
9

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

image
image2033×1270 168 KB

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

2 Likes