Replace -99999, -1999999

[Inactive User]

Hi,

I have a dataset. For some reason, the empty data cell was replaced by -99999, some of the cells was replaced by -1999999.

Is there any way to scan the whole dataset, remove this value and keep them empty?

Because the model will still take these -99999, -199999 value in the numerical variable as a valid value and output the  incorrect results.

Thank you.

[MarqueeCrew]

one idea for you:

use a formula tool and for that 'field' use a formula like:

IIF([field] in (-99999,-1999999),null(),[field])

this will revert the numeric value to Null if one of the bad entries exists, otherwise it will maintain the value.

please let me know if you need more help.

Cheers,

Mark

[jdunkerley79 · Accepted solution]

Would do the same as @MarqueeCrew but I'd use the Multi Field Formula tool and then you can do all the columns you need in one pass (just remember to untick the create new field box!!):

[Inactive User]

very good solution. Thank you.