âShow Table of Contents
The Formula tool creates a new column, or updates a column, using one or more expressions to perform a variety of calculations and operations. See Functions for a list of functions to use when building an expression.
Use the Formula tool to:
In the Configuration window, select an existing column of data in Select Column or add a new column.
Click the expression editor and build an expression. Once the workflow has been run, the Data Preview box displays the first row of data from the specified column with the expression applied.
Use any of these methods to build an expression:
Once an expression has been built, it can be saved for use at a later time.
With an expression in the expression editor, click Save Expression, type a name, and click Save.
It is helpful to add multiple expressions to a single Formula tool when modifying data in related columns or performing similar operations. When modifying unrelated data or performing unrelated functions, using multiple Formula tools assists with workflow troubleshooting.
To add an expression, click Add Expression.
The sequence that expressions are applied affects the results when multiple expressions modify the same data.
To reorder an expression, click and hold and drag up or down.
Because this tool includes an expression editor, an additional input anchor displays when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor. See Interface Tools.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.