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.

Find maximum by group

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.

Was this article helpful?
Cancel
Thank you!