How do I set a new field to be TRUE, FALSE or Null?

[MikeCarpenter]

I have

- a boolean field I need to set to TRUE when I create it

- an integer field I need to set to Null  when I create it

.. but I can't see how as these don't appear as standard constants??

I'm new to Alteryx, so may be missing something obvious..

Michael

[michael_treadwell · Accepted solution]

If you need a boolen field set to true, use the formula tool to create a boolean field and in the formula box use 1 == 1

If you need a null field use NULL() in the formula box

[MarqueeCrew · Accepted solution]

Some hints:

True is 1 and False is 0

Null is Null()

If I wanted to make an integer null, the formula would be:  NULL()

If I wanted to make a boolean True, I would use the formula:  1