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.
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.
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
Thank you!