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

Macro problem: the cell is not blank for a filter, do not filter rather than filter for ""

Asteroid

Hello there,

 

In my work, I met a super question which i can not resolve it with my head.... So i have created a simple macro in order to simplify the question.

 

I am trying to have a macro like this, which will filter the value regarding the value set into Control Parameter:

Capture.PNG

 

For example, if i set a cell "Yellow","Black", then my result after this macro will be:

Yellow

Black

 

if i set a cell "Yellow","Black", "Blue" then my result after this macro will be "Yellow","Black","Blue", then my result will be:

Yellow

Black

Blue

 

But in my work, i will have the cell with nothing but which means that do not filter anything...................

 

How can i make it? Crying now...

 

Thanks,

Bolide

Hi @Krasus! You are very close. I recommend using a Detour Tool and a Condition Tool inside your macro to bypass the filter if the data from the control parameter is "" or Empty. I built out what the solution would look like in the attached file. Hope this helps!

Labels