Multi-Field Formula Tool
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
- In the configuration window, select a data type from the dropdown.
- 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.
- 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.
- 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.
- 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.