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

Question

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

sample data.xlsx

AZuc · Answer

@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.

wtteleanor · Answer

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 · Answer

@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.

Filters Chained App1.yxzp