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

KevinSobel

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. 

field1	field2	field3
0	0	0

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

Any ideas why this is happening?

Thanks.

Multi-Field convert to nulls.yxmd

alisonpitt

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.