Filtering Null String Values

Reply
Visitor

Filtering Null String Values

I am trying to identify blank values in a field and assign a new value with a CASE statement. Is there a way to take care of this for string values yet? i've tried =''  as well as ISNULL, no results

Blue Belt

Re: Filtering Null String Values

Have you tried this?

 

Case When IFNULL(`YourTextField`,0) = 0 Then 'NewValue' Else `YourTextField` End

 

Hope it helps

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Moderator

Re: Filtering Null String Values

@evan_mchugh, did Godiepi's reply help you out?

Visitor

Re: Filtering Null String Values

Thanks for the suggestion! I thought that would do it when I saw it but unfortunately it still is giving me a syntax error. I double and triple checked spelling and syntax. matches your format.

 

Could it be the type of field it is in SFDC? I wouldn't think so because it comes into domo as a text value.

 

Thanks for the suggestion, I'll keep trying

White Belt

Re: Filtering Null String Values

When dealing with STRING values, you could follow the following Beast mode:

CASE WHEN `Text Value` = ' ' then 'Some String' ELSE 'NULL' END

 

Then just filter out the NULLS from whatever you named the Beast mode. I hope this helps! If not, please reach back out.

 

Thank you!

White Belt

Re: Filtering Null String Values

Try this:

CASE 

  WHEN TRIM(`YourField`) = '' OR `YourField` IS NULL

    THEN 'YourNewValue'

END

**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Moderator

Re: Filtering Null String Values

@evan_mchugh, tagging you to let you know about the above two replies in case you haven't seen them yet. 

White Belt

Re: Filtering Null String Values

I had the same issue and this one solved my problem. Thanks.

Yellow Belt

Re: Filtering Null String Values

JAROMP.....This worked perfect for me! You're a DOMO genius!! Thanks a bunch!!

Announcements
Call for Presenters! We want to hear your Domo story, submit your entry and win a free pass to Domopalooza 2019!. Click here!