Feeding Data to a Dropdown

[DataPirate26]

How to Feed a specific field from an input file to a drop down menu for selection and how to change the value through an action tool. In the attached excel File need to select the "Client Name" Field and give it to a drop down selection. Also required to change the selection as per user needs.

[atcodedog05]

Hi @DataPirate26 

Here is how you can do it.

Workflow:

1. Using crosstab tool to get client names as column names.

2. Using dynamic rename to replace underscore with spaces.

3. Pass these column names as drop down options.

4. In action tool setting to replace client name value in filter tool.

https://community.alteryx.com/t5/Interactive-Lessons/Creating-Drop-Downs/ta-p/243115

Hope this helps 🙂

[DataPirate26 · Accepted solution]

Thank you. This worked Perfectly good. Also Can you tell me how to Add Super Headers to the Drop Down Menu ?

example: Forecast Hours ( This will be the super header) 

               Select the Client Name 

               Dropdown Menu which consists of the client names 

[atcodedog05 · Accepted solution]

Hi @DataPirate26 

You can follow this interactive lesson to learn how to add super header.

https://community.alteryx.com/t5/Interactive-Lessons/Designing-App-Interfaces/ta-p/243110#done

Hope this helps 🙂 If yes please mark my response as solution.

[jdbartosh]

Solution uploaded