Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

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

MikeCarpenter
Átomo

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 RESPUESTAS 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.
Etiquetas
Autores con mayor cantidad de soluciones