Replace 0's with Null()

Question

Hi all,

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

Any help would be much appreciated

bmoss · Answer

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

dkma · Answer

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

dkma · Answer

How to apply this using multi field tool