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.
Solved! Go to Solution.
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.
Thanks.