Filter for multiple values, Analytic App

[wonka1234]

Hi,

I am trying to figure out how to incorporate filtering for multiple values in my analytic app filter tool.

Is it possible to filter for multi values ie  Toronto|New York|Miami ?

[Yoshiro_Fujimori]

@wonka1234 ,

I would not go with "text input" as the data quality of input data is not guaranteed.

[wonka1234]

@Yoshiro_Fujimori 

So one question on your answer, Can the Column to filter on be switched and then have those values populate?

Ie your workflow is set for City, but what if I wanted country in your "3_filter" file? Can I just have an option to drop down field to County then have the country options show? Ie GB US CA

[Yoshiro_Fujimori]

@wonka1234 ,

My apps are connected as below:

Step1: "1_prep_list.yxwz" outputs lists of values to "City.yxdb" and "Country.yxdb".

Step2: "2_select_column.yxwz" lets the user select "City" or "Column" and outputs the selected column name to "filterColumn.yxdb".

Step3: "3_filter.yxwz" lets the user select the values to filter from the list box and executes the filter on the original input sheet.

So once the column is selected at Step2, you cannot change it at Step3.

I tried to do the Step2 and Step3 on one App, but gave up.

I guess there may be a solution around "Block Until Done" tool, but not tried yet.