Empty into Nulls

[nwatzlaf]

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

[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 · Accepted solution]

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.