firstBy

firstBy returns the first row for each group.

Syntax

Parameters

ParameterTypeDescription
groupByColumnsString...

The column(s) by which to group data.

  • NULL returns only the first row in the table.
  • "X" will output the entire first row of each group in column X.
  • "X", "Y" will output the entire first row of each group designated from the X and Y columns.
groupByColumnsColumnName...

The column(s) by which to group data.

  • NULL returns only the first row in the table.
  • "X" will output the entire first row of each group in column X.
  • "X", "Y" will output the entire first row of each group designated from the X and Y columns.
groupByColumnsCollection<String>

The column(s) by which to group data.

  • NULL returns only the first row in the table.
  • "X" will output the entire first row of each group in column X.
  • "X", "Y" will output the entire first row of each group designated from the X and Y columns.

Returns

A new table containing the first row for each group.

Examples

In this example, firstBy returns the first row of the table.

In this example, firstBy returns the first row, as grouped by X.

In this example, firstBy returns the first row, as grouped by X and Y.