Drop Down input

Question

Hello,

I want to add drop down options on a column (column "Comment" below) in my Alteryx. How do I go about doing this? The "Comment" column is a new column that I added using the text input & union field, it is not in the source data. Thank you!

Column 1Column 2Column 3Comment (Drop down)   option 1   option 2

linhtranPI · Answer

Hi,

Yes, I'm new to this and thought I could replicate something like this in excel. Please see the attached example for how it would look in Excel.

This workflow would be run monthly to provide some monthly insights for the end user, who have to "comment" or respond with a required input.

Column A & B are parsed through some source documents, and the data would change. Column C is newly created in Alteryx, and should contain a fixed number of acceptable responses; this will not change. Essentially, this spreadsheet will contain anything between 0-100 rows that would require a response input from the end user.

Given that it looks like we will have to build a dropdown per row, I assume this is not possible since my rows will change depends on the monthly data?

DropDownExample.xlsx

mceleavey · Answer

Hi @linhtranPI ,

If you provide more information we can probably provide a better response,

You appear to be trying to replicate Excel functionality, which is not how it would be done in Alteryx as you would need to build a dropdown per cell per row.

Can you provide an example of the data, what you would like in the dropdown and how you want the data to update.

Could you also provide some information as to what the goal of this is?

Thanks,

M.