Find minimum by group

The Find minimum by group step calculates the minimum value in a column or a group of columns. This step is similar to the MIN function in Excel.

Input/output

Our input data is product names and its information.

After connecting it into this step, our output data is a minimum quantity of each product.

Settings

First, Pick the dataset, then type the name of column you'd like to Find minimum by group in under the "Min value column(s)" column, 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 minimum value of each.

Last updated