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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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