Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replace value with Blank not null()

subhajits11
8 - Asteroid

If [something]=1 then "it is one"

Else [Do Nothing] 

end if

 

I want my cell value should be blank.(Adding new column formula tool).i am not able to achieve [Do Nothing]  this part.

 

This is possible by "find replace " ,but I don,t think that's the solution.

 

Regards,

Subhajit

6 REPLIES 6
markcurry
12 - Quasar

If you don't want to add nulls, you can and an empty string "" instead....

 

IF [something] = 1 THEN
"it is one"
ELSE
""
ENDIF

 

You can check for Empty strings with that IsEmpty function.  Hope that helps

Bennel_Wilson
8 - Asteroid

Hi @subhajits11 ,

I agree with the approach of @markcurry . A simple formula tool with the formula should do the trick.

Bennel_Wilson_0-1589749824069.png

 

The result this step would leave all other cells with blank spaces, what I mean is they're necessarily not empty and in an excel output they wont show as blanks. See below: 

 

Screenshot (440).png

 

 

So as a final act, you could use a data cleaning tool to remove all such white spaces which should leave the result column with absolute blank cells. See below:

Bennel_Wilson_1-1589750073626.png

 Attached workflow for your reference.

 

Regards

Benn

 

P.S: In case this solves your query, kindly mark as solution.

 

 

 

 

subhajits11
8 - Asteroid

Thank you so much 

 

Bennel_Wilson
8 - Asteroid

Glad, I could help

Angelica_Obi
8 - Asteroid

i'm still getting null no matter the variation I type

RWJS
5 - Atom

you can also use Null, then data cleanse to a blank (you may need to revert to a string field first)

Labels