Replace -99999, -1999999

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.

Tips and Tricks

Accepted answers

jdunkerley79

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!!):

All comments

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

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!!):

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703