Select value from a column

[RoelEsselink]

Hello all,

I have a data set with the statistics for all plays made by quarter backs (QB) in an american football league. I now want to create a simple app that allows people to make an export of this data for one QB of their choosing. This means they will need to be able to select a value from the QB column (see attached 'raw data.xlsx'. I've tried to get it to work with filter, action and check box tools but can't seem to figure it out..

Can someone show me how to do this?

[andre347]

I see all of your data sits in the first column. If you had a list of QBs you could use a combination of a contains Filter (contains is an option in the filter tool) to filter to only the rows that mention the QB.

You would then also use that list in the 'Dropdown' Interface tool.

I've attached an example.

[RoelEsselink]

I do apologise. I attached the wrong file. Correct one attached now. Could you give me an example using this data? I can't figure it out :-(

[andre347 · Accepted solution]

New example attached. 

Click on the Magic wand nex to the run button to see the dropdown selection for the QB

[RoelEsselink]

Awesome. Thanks so much for:

a) the solution

b) the speed that solution was given

:-)

[andre347]

No problem. Happy to help out and enjoy the Alteryx journey!