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

Alteryx designer Discussions

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

Custom filter - dynamic

Highlighted
Asteroid

Hi,

is there a way in a custom filter to build a search box to find what user want to filter?

 

I have field1 in data set 1 , I want to apply a custom filter base on a list from a separate file that changes every month.

 

so I'm thinking [type] = "type from file 2"? is there a option for that? Thanks.

Alteryx
Alteryx

Hi BosKev,

 

I was able to accomplish this in something I worked on recently by putting the filter in a macro with a control parameter and action tool that updated the filter formula. Then you build the filter formula using the data from your file 2 and feed it into the control parameter. Your other data can pass through the macro input/output.

Filter Macro.PNG

Magnetar
Magnetar

Another way to do this is with a Find and Replace tool.  You can set it to Append field on match, and then filter for cases where your appended field is not null.  Then you can use a Select tool to remove the appended field.


Attached is a brief workflow with this example.

 

 Hope this helps!

Asteroid

Thanks Claje, this is close to what I'm looking for. is there a way to filter the different categories within field2 aka search terms? meaning after select the result of and and replace I want to be able to filter data, I , want, to , find into 5 separate output automatically. thanks.

Labels