community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Filter to Leave Cell Blank

Highlighted
Asteroid

Hello!

 

I am trying to create a filter which would intentionally leave a cell blank if it contained a certain value. More specifically, I'd like to leave a cell in the filename column blank if it contains the filename of a certain file. I believe I would need an if-then filter similar to the following:

 

if [filename] = "thisfile.xls" then (blank)

 

I am clearly a newbie to filters so any help would be appreciated. Thanks!

Alteryx Certified Partner

I imagine you'll want to perform this action in a Formula tool. Set the formula tool to update the [filename] field with this formula:

 

IF [filename]='thisfile.xls' THEN ""

ELSE [filename] ENDIF

 

If you wanted to take extra steps and use a filer, set the filter formula to this:

 

[filename]='thisfile.xls'

 

Connect a Formula tool to the true (T) output from the Filter. In that Formula tool, update the value for the [filename] field with ' "" ' and then Union those results to the False (F) output from the filter to achieve the same result. 

 

I've attached a solution that covers both.

Labels