community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Create a new column from drop down input

I'd like to create a new column in my data that contains a month string based on user input from a drop down. My data is a fairly simple Excel file with 3 columns (id, unit and counts). This data is run monthly and I need to add the month (in the form Jan, Feb, Mar....) in a column each time this data is run.

I thought it would be easy to use a dropdown tool to list the months, have the user choose the appropriate month and then have this month column appended to the data. But, I consistently get an error or "No Output Files". I've tried many variations on strings. I've tried using numbers and converting to months. I'd appreciate any help.

Thanks

Alteryx Certified Partner

Hi @laneytrax ,

 

I've attached a workflow which uses a date picker to select the date on which you're running it, that will then place the month in a column.

Remember to set your browse in the "Interface Designer" window to show the results.

 

Hope this helps.

 

M.

 

(For some reason I can't upload apps, so it's uploaded as a workflow)

Thank you so much! This is exactly what I needed.

Alteryx Certified Partner

You're very welcome, glad I could help.

Labels