Multiple levels of filters, first select columns to filter, then select filter values

[wtteleanor]

Hi,

I am new to Alteryx, and now I would like to build an app to help colleagues to filter records on their own.

First they could choose which fields/columns they would like to filter, maybe one field or multiple fields, such as "Branch", "Gender" and "Type";

Then, based on the result from the first step, they could choose multiple values to filter these columns, for example: "Branch" in ('01,'02'), "Gender" in ("M") and "Type" in ('AA','AB')

I know that I should use chained app for this, but couldn't think of a way to realize that goal.

Could anyone provide some advice on that？Thanks a lot.

Eleanor

[DawnDuong]

hi @wtteleanor 

Have you checked out this recorded video:

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

Dawn.

[wtteleanor]

Hi @DawnDuong 

So many thanks for your reply.

I had saw that video before, one column is easy to be done. The problem is, if the user wants to select more than one column to filter, maybe 3 or 5 columns, which depends on their requirement, is there any way to do this, instead of listing out all the possible columns that the user might select in the first chained app? Thanks a lot.

Eleanor

[DawnDuong]

hi @wtteleanor 

If users want to have N filters, then there need to be N interface tools to select and output in the first chained app as input to the 2nd chain App.

Dawn.

[AZuc]

@wtteleanor ,

See if this workflow could help you. It's incomplete, but it allows you to choose as many fields as you want, with the values.

The current output is the list of fields and values you will need to use to your filter.  

[wtteleanor]

Hi @AZuc ,

Thanks for your help. Is there any way to use List box instead of the tree tool? Especially when the description area is purely numbers, it's hard to figure out the meaning behind those numbers. 

[AZuc]

@wtteleanor ,

It will depend on how flexible you want to build your workflow. If you want something that can deal with any file, any number of columns and column names, I see no other way than to use the Tree. If you know the fields you can build different interfaces for each one of them.