Expression to Evaluate NULL Conditions

[maniruddha]

I joined to data sets by using JOIN and Union and the result provides me the desired results.  But one of the field/column called "Value" is empty and the output gives "Null" values.  I want to change those to 0 

So i used following statement in Formula tool

if IsNull([Value]) then 0 else [Value]

It gives me an error - "Malformed" If statement.  Please help.

New to Alteryx so any help would be appreciate.

[Thableaus · Accepted solution]

Hi @maniruddha 

"if IsNull([Value]) then 0 else [Value] endif"

You need to add an "endif" at the end.

Cheers,

[Thableaus]

@maniruddha 

To replace Null values you could also use "Data Cleansing" tool.

You can have the option to replace null values with 0 (that's exatly what you're trying to do with your Formula Tool).

Cheers,

[maniruddha]

Thank you so much!

[maniruddha]

Thank you so much!  Both worked!