Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Replace -99999, -1999999

Highlighted
8 - Asteroid

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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
16 - Nebula
16 - Nebula

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

2016-07-26_08-26-11.jpg

 

 

Highlighted
8 - Asteroid

very good solution. Thank you.

Labels