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

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Tool Mastery | Action

Community Data Engineer
Community Data Engineer
Created on

icon.pngThis article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Action Tool on our way to mastering the Alteryx Designer:

 

There’s a lot going on in the world of analytics. Endless data stores and insight are at the other end of an internet connection and, as analysts, we’re always in on the action. Being in the thick of the fray with data whizzing by at lightning speeds, being equipped with the right tools is a must. Like you, Alteryx also likes to live dangerously, and we’re always ready for action.

 

1.png

                                 Alteryx: Always ready for action

 

Easily the most commonly used interface tool, the Action Tool performs an update on a tool within an app or macro - usually in the form of changing initialized tool values, enabling or disabling tool containers, or deleting tools altogether:

 

2.png

 

Nearly every other interface tool can interact with the Action Tool as well, with the Q Anchor.PNG anchor accepting zero to many input user values and the Conditional Anchor.PNG anchor linking the update to a condition evaluated upon run time. The Lightning Anchor.png anchor then links the Action Tool to the target tool to be updated. Since there’s no shortage of combinations for target tools and input variables, the highlight reel of the Action Tool isn’t specific to any one tool. Lights, Camera, Action!

 

  • Update specific strings in tool configuration

If you have “Update Value” selected and “Replace a specific string:” is checked off in your configuration options, the string that remains in the following line of text will be the exact string replaced in the selected value. It will be replaced by the value entering the Q Anchor.PNG input of the Action Tool:

 

3.png

Just run the attached app, Action Tool.yxwz, to see the result of the above!

 

  • Update tool values from formulas (multiple input example)

Similar to string replacement, you can select “Update Value with Formula (Default)” to replace a target tool attribute with a formula that can use all the same functions of the Formula Tool. This will, however, update the entirety of the specified attribute with the result of the formula entered, often using the Q Anchor.PNG anchor to incorporate user input values from other interface tools:

 

4.png

This example is also attached.

 

 

By now, you should have expert-level proficiency with the Action Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know at community@alteryx.com if you’d like your creative tool uses to be featured in the Tool Mastery Series.

 

Stay tuned with our latest posts every Tool Tuesday by following Alteryx on Twitter! If you want to master all the Designer tools, consider subscribing for email notifications.

Attachments
Comments
Bolide
"By now, you should have expert-level proficiency with the Action Tool!"

With all due respect, this covers the simplest 2 of 19 action types...  literally slightly above 10% of the tool's capabilities.  Any chance you could dive a little deeper into some Action Tool Mastery for a couple of the more complicated methods, such as Update Raw XML with Formula or Update Field List or Update Select with Reverse Field Map ?

 

Kindest Regards,

 

Taylor Cox

Moderator
Moderator

Hi All,

 

Just adding a note for anyone that may be looking fore more resources on the action tool.  There is a one tool sample installed starting in version 11.7  that contains some additional configurations for the action tool.

 

2017-12-22_8-18-30.png

 

Thanks,