We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

action tool

Inactive User
Not applicable

Hi, team. I have many columns in the data set. I want to multiply 2 columns and want to give user values how it is changing but those 2 columns are not coming up in the action tool. Please help 

Thatiparti_0-1656594986712.png

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @Inactive User,

If you want to update a select tool I would recommend using a drop down box or list box:

IraWatt_0-1656595189870.png

They give this nice option in the action tool which makes it easy:

IraWatt_1-1656595245160.png

Any questions or issues please ask :)
HTH!
Ira

 

 

dana_mcdonough
Alteryx Alumni (Retired)

Hi @Inactive User : I can't see where you're action tool is connected. Can you show in your screenshot and/or upload your workflow? You need to ensure that the columns in question exist in the step in your workflow to which you are attaching the Action Tool.

apathetichell
20 - Arcturus

numeric up down is used to input a number. Select tool is used to choose a field. A field is stored as "[fieldname]"  - which is not a number.

 

If you want to have the user choose numbers connect your action tools to a two column text input which has two numbers in it (say [field1] and [field2]) have the action tools update row 1/column 1 and row1/column 2. use a formula tool to have [field1]*[field2] and attach a browse. use interface designer to configure your browse tool to show on output.

 

You would use a dropdown or list box tool with a select tool (in update select mode) or a text input field with a select (in other modes). There is obviously some variation here but using a numeric up down with a select tool would be incredibly unusual (I personally can't think of a use-case where I'd do this - but I'm sure it exists).

Labels
Top Solution Authors