Null to Empty

I have a numeric field created by a formula. For many records, that formula results in a NULL. Ultimately in my CSV output, I want those NULLs to be EMPTY. I can use Impute to convert NULL to zeros, but not seeing how to convert them to EMPTY.

Thank you for suggestions!

Preparation

Accepted answers

MarqueeCrew

Erin,

Have fun at the Alteryx User's Group meeting today!

The final soltuion was very close...

IIF(ISNULL([My_Field]) || [My_Field] == '0','',[My_Field])

Mark

All comments

MarqueeCrew

How about a formula:

IIF(ISNULL([My_Field]),'',[My_Field])

That's what I'd use.

P.S. Then the field will need to be a STRING, but that won't be an issue if you are outputting to CSV. You'd need a SELECT before the formula to change the type.

erin_kotch

I wish that worked! The browse shows EMPTY but the CSV output is zeros.

BTW - the P.S. to your post did teach me something, so even though it didn't work here, you definitely helped me on something down the road! Thanks!

@MarqueeCrew wrote:
How about a formula:
IIF(ISNULL([My_Field]),'',[My_Field])
That's what I'd use.
P.S. Then the field will need to be a STRING, but that won't be an issue if you are outputting to CSV. You'd need a SELECT before the formula to change the type.

ssjl

Forgive me for posting to an older thread; if running version 10.6 or later use the Data Cleansing tool (Preparation).

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703