Empty into Nulls

Hi there,

I am trying to turn records that are empty in a certain field into NULLs so that I can use countNulls in a formula later on in the workflow. I have used several IF statements in formulas but I am not seeing the cells output as NULL in my result.

I have tried ...

IIF(IsEmpty([TRACKING_NUMBER]),Null(),[TRACKING_NUMBER])

Any help would be appreciated!

Thanks,

Natalia

Best Practices

Accepted answers

Thableaus

Hi, @nwatzlaf

Quick tip - use the Data Cleansing tool on your TRACKING NUMBER field before you use this formula

It could be the case where you have some spaces on your records and they might not be considered an empty record.

Cheers,

All comments

NickSm

Hi @nwatzlaf

Wondering if it's due to data types, is your Tracking_Number numeric or a string? If it's not a string, I'd try it with converting that field beforehand.

Thableaus

Hi, @nwatzlaf

Quick tip - use the Data Cleansing tool on your TRACKING NUMBER field before you use this formula

It could be the case where you have some spaces on your records and they might not be considered an empty record.

Cheers,

nwatzlaf

It worked! Thanks so much @Thableaus !

NeilFisk

Is there a way to apply this type of equation to multiple fields at the same time? I have a lot of fields unfortunately that I first run through the Data Cleansing tool (which is slow to run) and then I would like to cleanse the data further by replacing empty with null on all fields. Once run, I would then have a cleaner data set to work with downstream.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703