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





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.

Updated on: 20/09/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!