minBy
minBy
returns the minimum value for each group. Null values are ignored.
Syntax
table.minBy()
table.minBy(columnNames...)
Parameters
Parameter  Type  Description 

columnNames  String...  The column(s) by which to group data.

columnNames  ColumnName...  The column(s) by which to group data.

columnNames  Collection<String>  The column(s) by which to group data.

Returns
A new table containing the minimum value for each group.
Examples
In this example, minBy
returns the minimum value for each column.
source = newTable(
stringCol("X", "A", "B", "A", "C", "B", "A", "B", "B", "C"),
stringCol("Y", "M", "N", "O", "N", "P", "M", "O", "P", "M"),
intCol("Number", 55, 76, 20, 130, 230, 50, 73, 137, 214),
)
result = source.minBy()
 source
 result
In this example, minBy
returns the minimum value, as grouped by X
.
source = newTable(
stringCol("X", "A", "B", "A", "C", "B", "A", "B", "B", "C"),
stringCol("Y", "M", "N", "O", "N", "P", "M", "O", "P", "M"),
intCol("Number", 55, 76, 20, 130, 230, 50, 73, 137, 214),
)
result = source.minBy("X")
 source
 result
In this example, minBy
returns the minimum value, as grouped by X
and Y
.
source = newTable(
stringCol("X", "A", "B", "A", "C", "B", "A", "B", "B", "C"),
stringCol("Y", "M", "N", "O", "N", "P", "M", "O", "P", "M"),
intCol("Number", 55, 76, 20, 130, 230, 50, 73, 137, 214),
)
result = source.minBy("X", "Y")
 source
 result