We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Alteryx Designer Discussions

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

Make the Filter Tool Optional based on Drop Down Value

S-9
7 - Meteor

Hi

 

I would like to use the action tool to update a filter based on values from the dropdown.  

The dropdown would also have a manual value "All" which if selected, should eliminate the filter tool from filtering anything and pass all records. 

 

Here is an example: 

Filter by Employee only has two values: Y and N

Add a Manual Text in drop down saying "All"

If "All" is selected, pass records for employees and non employees. 

 

It does not seem to work when I select All. Any information would help!

Thanks

 

 

2 REPLIES 2
TheOC
12 - Quasar

hi @S-9 !

Sorry for the delay in replying to you! This one had me stumped a little bit, but i've found a solution!

I'm sure theres a cleaner solution, but alas:

TheOC_0-1603834931838.png



within my macro:

TheOC_1-1603834948325.png



In a what feels like a hacky way - I am setting the value of each variable they can choose. Here Y and N are clear, but I add the OR conditional within the ALL selection. Wiithin my action:

TheOC_2-1603835001704.png



I have chosen to replace a specific string.


I have attached a packaged workflow with my macro, hope this helps!





S-9
7 - Meteor

that worked great! THANKYOU!

Labels