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
Solved! Go to Solution.
solved the last part with an If statement.
If IsNull([Replacement Order#]) then "N"
else [Replacement]
endif