Multi-Row Formula Tool
Use the Multi-Row Formula to create a new or update an existing column using an expression that references multiple rows. This can be useful for parsing complex data, creating running totals, averages, and percentages, and performing other mathematical calculations.
The Multi-Row Formula tool can only update 1 column per tool instance. If you want to update multiple columns, add a Multi-Row Formula tool to your workflow for each column you want to update.
Configure the Tool
Update Existing Column: Updates an existing column.
Output Column: Select the column to update with an expression.
Number of Rows: Enter the number of rows to apply the expression to.
Enter an Expression to apply to the column you selected.
Select the Values for Non-Existent Rows. This sets the value to be used in the calculation if no row is selected by your expression:
NULL: Null values are applied to nonexistent rows.
0 or Empty: The values are set to 0 or left empty. This is the default option.
Set to Values of Closest Valid Row: The values of the closest valid row are set to the nonexistent rows.
Create New Column Creates a new column.
Output Column: Enter a name for your new output column.
Type: Select the data type for your new column from the dropdown.
Number of Rows: Enter the number of rows to apply the expression to.
Enter an Expression to apply to the column you selected.
Select the Values for Non-Existent Rows. This sets the value to be used in the calculation if no row is selected by your expression:
NULL: Null values are applied to nonexistent rows.
0 or Empty: The values are set to 0 or left empty. This is the default option.
Set to Values of Closest Valid Row: The values of the closest valid row are set to the nonexistent rows.
Group By (Optional): Either check fields individually or use Select All. If your data contains 4 or more columns, you can use the search bar to search for a specific column.
Important
You can access the Num Rows functionality through the x button in the expression editor.