Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

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

MikeCarpenter
5 - Atom

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

 

2 REPLIES 2
michael_treadwell
ACE Emeritus
ACE Emeritus

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
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels