Expression to Evaluate NULL Conditions

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.

Code-Value Table.xlsx

ID-Code Table.xlsx

Left outer Join WFLO-2.yxmd

Error Message

Accepted answers

Thableaus

Hi @maniruddha

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

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

Cheers,

All comments

Thableaus

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! Both worked!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280