Articles on: Transforms

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.

Find maximum by group


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".


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.

Updated on: 20/09/2022

Was this article helpful?

Share your feedback


Thank you!