Articles on: Transforms

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.

Find minimum by group





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.

Updated on: 20/09/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!