Converting Null value to zero

[haya]

Hi Team,

Can you please let me know how to convert null values of a numeric field to zero as I am facing issue with division because of this (Something equivalent to coalesce function in sql).

Also can you let us know how to do vlookup in alteryx.

Regards,

Haya

[elsa2020]

I believe I have the right boxes ticked as you have them. I have attached a screenshot of my work as this is non sensitive info for my Alteryx class.  Kindly advise Thanks

[Rich_Stebles]

Can you attach either the packaged workflow or a few more screenshots please?

In the screenshot I can only see the set up for your Input Data tool, so I don't know what your set up for the Data Cleansing tool is and I can't see the results with the nulls still in them.

Thanks

[Rich_Stebles]

One other thing to try is whether the field looks like a number but is in fact a string.  Have a look at the meta info or drop a Select tool after your Input Data to see what the field is, possibly the formatting in your excel datasource is funky and Alteryx is reading it in as a string.

[Adrien_Sourdille]

Spoiler

[sdeckrow]

This is life changing.  Thanks!