Alteryx Designer Desktop Discussions

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

isnumber(v) isn't recognising a number

GaryKennedy
6 - Meteoroid

Hi Alteryx Community,

 

I am new to Alteryx so apologies if my question is basic.

 

I want column named "Replacement" to populate with True if there is a number in field "replacement order#" and to populate with False if a letter is in column "replacement order#"

 

I tried ISnumber[replacement order#] but it is showing 0 for all entries.

 

One of the numbers I am trying to return as True is is "40116486, 142698960".

 

I appreciate any help on this.

 

Regards,

Gary

 

 

 

10 REPLIES 10
GaryKennedy
6 - Meteoroid

solved the last part with an If statement.

 

If IsNull([Replacement Order#]) then "N"
else [Replacement]
endif

Labels