Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Can't change fields to null using Multi-Field tool

KevinSobel
6 - Meteoroid

I am trying to change multiple fields to nulls using the Multi-Field tool and get the following warnings:

 

Start: Designer x64: Started running at 05/24/2023 17:14:07
Info: Text Input (1): 1 record was output
Warning: Multi-Field Formula (2): The formula "field1" resulted in a integer but the field is a string.
Warning: Multi-Field Formula (2): The formula "field2" resulted in a integer but the field is a string.
Warning: Multi-Field Formula (2): The formula "field3" resulted in a integer but the field is numeric.
End: Designer x64: Finished running in 0.4 seconds with 3 warnings

 

 

I get 0 in all of the columns instead of null. 

 

field1field2field3
000

 

 

I've attached the sample workflow that produced the above results.

 

Any ideas why this is happening?

 

Thanks.

 

 

2 REPLIES 2
alisonpitt
11 - Bolide

All you need to do is change the formula here - the zero is because you're evaluating the expression "[_CurrentField_] = null()", which is evaluating as false (0). If you just use null(), then it will set the values all to null.

nulls.png

KevinSobel
6 - Meteoroid

Thanks.

 

 

Labels