Remapping nulls in Analyzer

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!

Best Answers

  • MarkSnodgrass
    Answer ✓

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • DashboardDude
    edited December 2023 Answer ✓

    @Victoria_G1

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

    Let me know if that makes sense!

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

Answers

  • MarkSnodgrass
    Answer ✓

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • DashboardDude
    edited December 2023 Answer ✓

    @Victoria_G1

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

    Let me know if that makes sense!

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter