Replace 0's with Null()

[dkma]

Hi all,

Does anyone know how to replace 0's with Nulls in alteryx. 

Any help would be much appreciated

[Emil_Kos]

Hi @dkma,

Please try using a formula tool and use the below formula:

IF [Field1]=0 Then null() else [Field1] ENDIF

[dkma]

How to apply this using multi field tool

[dkma]

Hello, I figured it out. thanks for the quick reply 🙂

[bmoss]

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