Skip to main content

​
Input/Output

Our input data has 11 rows of order information showing us how many items were sold, the food type, the customer name, and their payment type.
Input data with 11 rows of orders showing Quantity Sold, Food Type, Customer Name, and Payment Type
If we instruct the step to find the maximum value in the ‘Quantity Sold’ column, and create one new row per value in the ‘Food Type’ column, we can easily find the largest sale of each item.
Output data showing one row per Food Type with the maximum Quantity Sold for each item

​
Custom settings

This step has no default behavior, and must be customized to return a useful output. First, decide whether you would like to include or exclude given columns by selecting ‘the following columns’ or ‘all columns except for’.
Custom settings panel showing the 'the following columns' versus 'all columns except for' toggle
Next, click the plus sign to choose the columns you wish to include or exclude.
Settings panel with the plus sign opened to add specific columns to include or exclude
If the ‘Create a new row…’ option is left blank, the step will return one value per column, according to your specifications in ‘Find the maximum value in’
Settings panel with 'Create a new row' left blank, returning a single max value per selected column
To find maximum values for multiple attributes, you can create a new row for each unique value in your table. As before, you can include or exclude given columns, and you can click the plus sign to specify.
Settings panel configured to create one new row per unique value in a chosen grouping column

Output table with grouping columns added left to right and a new max column appended on the right
Unique value columns will add left to right, and sort A-Z, and your desired maximum value will display as a new column with “(max)” appended to its header.
Last modified on May 18, 2026