Beaker with liquid and stir-stick.

Multi-Field Formula Tool

Version:
2021.3
Last modified: August 12, 2021

One Tool Example

Multi-Field Formula has a One Tool Example. Visit 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

Image showing the Multi-Field Formula tool on the Designer canvas.

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 apply the formula to. Only the fields that are of the specified data type display. Select fields individually or use All or Clear.
  3. Check Copy Output Fields and Add and select Prefix or Suffix to create new columns for the data. Uncheck to update the data in the original columns.
  4. Select a data type in Change Output Type to to change the data type of the values in the column. Use Size (the size of the data type) to update manually for string data types.
  5. Build an expression either by entering text directly in the expression editor or by double-clicking a variable or function to add it to the expression editor. Visit Expression Editor for more information.
    • _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.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.