Dynamic Filter for Specific Column

I have a data set that contains a list of Company codes in column A. I am wanting an option in the interface tool to either run the output for all companies (default) or only specific ones that are selected from a drop down.

I am not sure I have this tool configured appropriately so any help getting me there would be appreciated.

There are no NULL fields so my logic is that all files would push through the filter by default, unless deselected in the app, which would then only push through those that are selected.

Dynamic Processing

Preparation

Interface Tools

Accepted answers

Jonathan-Sherman

Hi @Cbennett022,

I would go along the lines of using a listbox connected to the filter to achieve this:

The action tool is set up as below to replace the values sitting inside the IN() function of my filter:

The interface gives me a list of all companies (mocked data set) ticked by default. Un-ticking any will remove them from the filter.

Un-ticking all companies apart from G and L in the interface:

Resulting in a data set just filtered for G and L:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200319 FilterForListBox.yxzp

All comments

echuong1

I would use a check box in addition to the drop down.

Essentially, you can use a check box tool to select if the user wants to pull all values, or only certain ones. From there you can use detour tools to specify which "path" in the workflow it will follow. One of them will be a filter tool with the drop down interface/action tool like you have, while the other will be nothing.

See the below article for information on the detour tool:

https://help.alteryx.com/current/Detour.htm

It will look something like this.

Jonathan-Sherman

Hi @Cbennett022,

I would go along the lines of using a listbox connected to the filter to achieve this:

The action tool is set up as below to replace the values sitting inside the IN() function of my filter:

The interface gives me a list of all companies (mocked data set) ticked by default. Un-ticking any will remove them from the filter.

Un-ticking all companies apart from G and L in the interface:

Resulting in a data set just filtered for G and L:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200319 FilterForListBox.yxzp

Cbennett022

Thank you both for the quick responses!

I am currently using a check box but is my action tool configured accurately? I cannot open you package as I am in an older version.

Another thing to note that may impact this.

The file I am outputting is an excel template. It has 3 tabs I created manually in excel that are updated by formulas, pulling from a sheet that is generated by my workflow and pushes into the template. The workflow generates 3 additional sheets that also push into this template.

I then replicate this template for each company (300 files). When I select which file to output, only the true template is made available, but none of the replicated template, which is what I need to be output. The original template serves just as that, a template. Any idea what may be driving this issue?

Cbennett022

Can you post a sample workflow of the detour that you screenshot so I can see how it is configured? I cannot seem to replicate it.

Cbennett022

Is there a way to nest this with a radio button?

I have one radio button that disables a container if I need to run container 1, and would like to have a radio button to disable container 2, that would then let me choose which companies to include in the filter

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335