Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Feeding Data to a Dropdown

DataPirate26
9 - Comet

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.

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @DataPirate26 

 

Here is how you can do it.

 

Workflow:

atcodedog05_0-1625829411357.png

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
9 - Comet

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
22 - Nova
22 - Nova

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
8 - Asteroid

Solution uploaded

Labels