Alteryx Designer Desktop Discussions

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

Question about Drop Down Tool/Action Tool to fill Column Values

lp_hall
8 - Asteroid

Hello,

 

I am attempting to use a combination of a Drop Down Tool and an Action Tool to fill numerical month values into a column called "Month1".

 

lp_hall_0-1621364565836.png

 

Starting with the Drop Down Tool, I have created a list of months in numerical value, 1 through 12, for the user to choose from.

 

lp_hall_1-1621364634243.png

 

On the Action Tool, I have selected Formula > FormulaFields > FormulaField > @expression - value="1" and "Replace a specific string" is set to 1. I have it set to this only because this is the first numerical month option.

 

lp_hall_0-1621365230469.png

 

I believe my problem lies with the Formula tool that all this feeds into. I currently have the output column set to [Month1] and simply a "1". I would expect this to change values as the user's input changes from the Drop Down Tool, but it doesn't.

 

lp_hall_3-1621365024366.png

 

I would like the user's selection from the Drop Down Tool to fill each row of the field [Month1]. I would expect it to look something like this.

 

lp_hall_2-1621364825866.png

 

However, when I run the workflow as an app, I get an error message saying there were no output files. If I selected, let's say 4, from the drop down, the values in field [Month1] remain 1. I would expect the column to be filled with 4's instead.

 

Where am I going wrong? Any help would be appreciated!

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @lp_hall I think a numeric up and down would be a better choice of tool as you can limit the value users input to 1-12. I think the action tool needs to be looked as the option that is selected or highlighted controls what the action tool try to update. I mocked up an example of your workflow and attached to this post and my example was updating. Can you share your workflow with sample data?

 

APP_18052021.JPG

lp_hall
8 - Asteroid

@JosephSerpis,

 

Thank you for your quick reply. I just updated my post to include a screenshot of what I have selected in the Action Tool. As mentioned before, I have selected Formula > FormulaFields > FormulaField > @expression - value="1" and "Replace a specific string" is set to 1.

 

I'm not sure I understand the benefit of the Numeric Up/Down Tool. Using the Drop Down Tool, I can limit the user's selection to only values between 1-12 just like I would be able to with the Numeric Up/Down Tool. The Drop Down Tool has a cleaner interface in my opinion.

 

lp_hall
8 - Asteroid

Hi again @JosephSerpis,

 

I have incorporated your workflow into mine and I believe it will work as intended but there are a few other pieces of the workflow I need to finish first before I can confirm it works. I will hold off on accepting your answer as the resolution for now but will definitely get back to you later. Thank you for your help thus far.

Labels