Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Replace value with Blank not null()

Highlighted
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

Highlighted
11 - Bolide

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

Highlighted
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.

 

 

 

 

Highlighted
8 - Asteroid

Thank you so much 

 

Highlighted
8 - Asteroid

Glad, I could help

Labels