Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
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.
Highlighted
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