Converting Null value to zero

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

Tips and Tricks

Transformation

Accepted answers

All comments

LordNeilLord

@haya,

For null to zero check out https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Data-Cleansing/ta-p/31753

For VLOOKUPs check out https://www.alteryx.com/alteryx-for-excel

haya

Hi Thanks for your reply ,But I am looking for a function which converts null to 0.Is there any relevant function which is equivalent to coalesce.

Regards,

Haya

Alteryx_AR

Imputation tool can also be used to replace Null with any user specified value.

mbarone

You can always use the ToNumber() function. For example ToNumber([your_numeric_field_here]). It will take nulls for a numeric field and set them to zero.

Adrien_Sourdille

Spoiler

challenge_8_start_file.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703