Remapping nulls in Analyzer

Victoria_G1

Hello,

I have a question about the remapping nulls function in Analyzer. Maybe I am not understanding what this function is supposed to do, but basically I am trying to replace all blank cells in a column with another numerical value. However, when I do it through the remapping nulls function, I see no change in the cells (screenshot attached)

Many thanks for the help!

MarkSnodgrass

The remap nulls likely isn't working because the data contains blank spaces instead of actually being null.

I would suggest dealing with this by creating a beast mode in Analyzer that looks like this:

CASE WHEN LEN(TRIM(fieldname)) >= 1 THEN fieldname ELSE replacementvalue END

This will trim out all the spaces and then check the length of the field. If it is at least 1 character then use the existing value. Otherwise, use a value you want to replace it with.

DashboardDude

@Victoria_G1

Here are a couple ways to replace that blank: https://www.loom.com/share/c0f06cc207ed4bf187b3e3dd6fcce975

Let me know if that makes sense!

MarkSnodgrass

The remap nulls likely isn't working because the data contains blank spaces instead of actually being null.

I would suggest dealing with this by creating a beast mode in Analyzer that looks like this:

CASE WHEN LEN(TRIM(fieldname)) >= 1 THEN fieldname ELSE replacementvalue END

This will trim out all the spaces and then check the length of the field. If it is at least 1 character then use the existing value. Otherwise, use a value you want to replace it with.

DashboardDude

@Victoria_G1

Here are a couple ways to replace that blank: https://www.loom.com/share/c0f06cc207ed4bf187b3e3dd6fcce975

Let me know if that makes sense!