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.
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
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.
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.
