Skip to main content

Beaker with liquid and stir-stick. Multi-Field Formula Tool

One Tool Example

Multi-Field Formula has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.

Use Multi-Field Formula to create or update multiple fields using a single expression.

Tool Components

Thumbnail

The Multi-Field Formula tool has 2* anchors.

  • Input anchor: Use the input anchor to connect the data you want to update.

  • Output anchor: The output anchor outputs the transformed data.

*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.

Configure the Tool

  1. In the Configuration window, select a data type in Select Fields. Choose from...

    • Numeric

    • Text

    • SpatialObj

    • Bool

    • DateTime

    • Time

    • All Types Of

  2. Select the fields (columns) to which the formula should be applied. Only the fields of the specified data type are displayed. Select fields individually or use the All or Clear buttons for bulk options.

  3. Check Copy Output Fields and Add and select Prefix or Suffix to create new data columns. Uncheck to update the data in the original columns.

  4. Select a data type via Change Output Type to checkbox to change the data type of the values in the column. Use the Size field (the size of the data type) to update manually for Fixed Decimal, String, Date-time, Time, or Spatial Object data types.

  5. Build an expression (either enter text directly in the expression editor or use the expression editor to select variables or functions to add to the expression editor). Go to Expression Editor for more information. These options are available as part of the Columns and Constants ("X" button in the expression editor) for this tool:

    • _CurrentField_: Uses the selected field in the function.

    • _CurrentFieldName_: Uses the name of the selected field in the function.

    • _CurrentFieldType_: Uses the data type of the selected field in the function.

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.