View All Docs
Hide Navigation
Product overview
Account overview
Transforms   ->

Find max by group

The Find max by group step calculates the maximum value in a column or a group of columns. This step is similar to the MAX function in Excel.


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.

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.

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.

Next, click the plus sign to choose the columns you wish 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...

To find maximum values for multiple attributes, you can Create a new row for each unique value in your desired columns. As before, you can include or exclude given columns, and you can click the plus sign to specify.

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.