Free Trial

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
Top Solution Authors