RESUELTAS
How do I set a new field to be TRUE, FALSE or Null?
Opciones
- Suscribirse a un feed RSS
- Marcar tema como nuevo
- Marcar tema como leído
- Flotar este Tema para el usuario actual
- Favorito
- Suscribir
- Silenciar
- Página de impresión sencilla
MikeCarpenter
Átomo
09-20-2016
07:35 AM
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
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
¡Resuelto! Ir a solución.
Etiquetas:
- Etiquetas:
- Preparation
2 RESPUESTAS 2
michael_treadwell
ACE Emeritus
09-20-2016
07:39 AM
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
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
09-20-2016
07:40 AM
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
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.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.