Create Drop-down list and Output as Excel format
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to create a simply drop-down with 3 defaulted choices so whoever get the excel file will be able to fill in as quick as possible
for example:
I have an excel input with 2 fields (Product & Product_ID)
Product | Product_ID |
A | 1 |
B | 2 |
C | 3 |
I want to add a new field Product_Name and have a drop down for people to select easily. the dropdown should have 3 values (Apple, Sam, Hua).
Product | Product_ID | Product_Name |
A | 1 | |
B | 2 | |
C | 3 |
thank you so much for your help once again! Alteryx community is amazing!
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you looking for different product name for each row or same for all rows.
If its same for all rows. This might help you https://community.alteryx.com/t5/Interactive-Lessons/Creating-Drop-Downs/ta-p/243115
If its different for each row its a complicated scenario.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hello there, thanks for the help!
actually i am just trying to insert the drop-down list with 3-5 options into an existing column or new column and then output as an excel file so whoever get the Excel file will be able to freely choose from those 3-5 "default options" as quickly as possible.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks for help! however, the actual data is way more intensive than the demo i just show. There will be around 500+ rows and data so will it still be ok by using your suggested solution? thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hello there my friend, i find it difficult to insert the "Drop-down list" into my existing excel file through Alteryx. Is it also applicable to a "Formula" tool instead of the input file tool?
May I request you do a more detailed demonstration if you have time to do so? thanks so much!
