Dropdown List in Excel Output from Alteryx
- 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
Hi Alteryx Community,
I am trying to generate a dropdown list in my Alteryx output to an Excel spreadsheet.
I want the cells in the column Result to be a dropdown list with values from either 'Success', 'Failure' and 'Inconclusive'. I want the user of the Excel file to be able to select from the dropdown list.
Any ideas?
Thanks!
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It is not possible to use alteryx to output a drop down list in Excel.
Alteryx is a data preperation and analysis tool. I'm not sure why you would want to use Alteryx to create your drop down lists, surely it's simple to do in excel itself?
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just to add a note here. Technically this is possible but you'd have to learn how Excel generates these drop down lists and where it is stored in the xml that forms a excel file. Then use Alteryx to write this xml.
A needlessly complex task IMO.
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Ben.
It is simple enough in Excel. I was just trying to see if I can reduce the manual step in the Excel output after the data preparation steps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
simran, I also have an interest in having alteryx produce an excel output file with data validation characteristics. Yes, it is easy to put them into excel files, but if I don't have to touch that excel output, that is even better.
Excel files are a comfortable place for many on my team to interact with data. These users will not have alteryx. After the users have interacted with the data, alteryx will read the excel files again to prep and blend data. Data validation would be a very useful feature. Being able to restrict what is added or done with the excel file would also be desirable.
papalow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a similar use case where the end user want a drop down list for one column. This excel file is shared with a large number of people and will be concatenated with data a number of times so the business doesn't want anyone to make spelling mistakes.
Lets hope alteryx introduces this feature in future releases.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is there any update if alteryx produce an excel output file with data validation characteristics? I am curious as I need this for one of my workflows.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I had this issue and I ended up recording a macro to create the validation, and if I have a folder of alteryx excel outputs, I wrote some VBA to make the macro iterate through the whole folder, creating dropdowns and saving each file. However, I have not been able to get the VBA to consistently work with all kinds of excel (regular sheet works fine, if it has tables, I have to trigger the macro by hand). Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @simran_d_
Maybe you can do this flow step:
1- create a template xlsx, add data validation in result ranges of sheet 'Output'.
2- In Alteryx 2020.2.2, Output your data to your xlsx of Oder folder. [pick option "Preserve Formatting on Overwrite(Range Required)" ]
3- If you need output more than 1 xlsx to same place, you can run command to copy template xlsx to these path before output data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am also following the same steps but it didn't help in retaining the dropdowns in the alteryx output file.
