Hi all,
Does anyone know how to replace 0's with Nulls in alteryx.
Any help would be much appreciated
Hi @dkma,
Please try using a formula tool and use the below formula:
IF [Field1]=0 Then null() else [Field1] ENDIF
How to apply this using multi field tool
Hello, I figured it out. thanks for the quick reply 🙂
select all fields to which this needs apply in the multi-field formula tool and place the following expression:
if [_CurrentField_]=0 then null() else [_CurrentField_] endif