Find maximum by group

The Find maximum 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.

Input/Output

Our input data is showing up the "Product" and its "Quantity".

After connecting the data to this step and setting it up, it shows the maximum value in "Quantity" column for each "Product".

Settings

First, Pick the dataset, then type the column name of "Max value column(s)", then type the name of "Group by column(s)".

You've now successfully completed this step's set up! The columns will be grouped as chosen and will show the maximum quantity of each.