Multi-Field Formula tool icon

Multi-Field Formula Tool

Last modified: September 09, 2021

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

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

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

Configure the Tool

  1. In the configuration window, select a data type from the dropdown.
  2. Select the columns to apply the formula to. Only the columns that are of the chosen data type display. Select columns individually or use Check All to select all columns.
    • Running a workflow can introduce new columns that were unknown at configuration time. Check Dynamic or Unknown Columns to include dynamic or new columns created after running a workflow.
  3. Select Create New Columns to create new columns for the data. Otherwise, select Overwrite Existing Columns.
    • If you are creating new columns, select a New Column Header Format and enter a Prefix/Suffix for the new column header.
  4. Check Change Output Type to change the data type of the values in the column. Select a Type from the dropdown and use Size (the size of the data type) to update manually for string data types.
  5. Build an expression by entering text directly in the expression editor, or by dragging or double-clicking a variable to add it to the expression editor.
    • _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.
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.