Filter based on Results from a List Box

[sbaker]

I would like to filter a data set based on results from a List Box.  The List Box is populated by values, not columns; I cross tabbed a column [Project ID] to populate the List Box.  Ideally I would like to build a table with the original column name [Project ID] and values from the List Box, and then Inner Join that new table with the original data set to filter out rows not chosen in the List Box.

I have attached the app workflow.  I believe the current configuration is incorrectly joining [Project ID] (right anchor) on the actual values from List Box (right anchor), instead of a column name.

[JordanB · Accepted solution]

Hi @sbaker

I have attached a V2 which actually incorporates a filter to just pass through the ID's selected in the dropdown.

As a result, only these IDs will be eligible for the join back to the original table. 

Factors I changed in your list box interface:

- We needed a '-' instead of a ' ' because your IDs had a '-' in them. 

- Changed to generate custom list for the IN function within the filter tool. 

Best,

Jordan Barker

Solutions Consultant