lastBy

lastBy returns the last row for each group.

Syntax

Parameters

ParameterTypeDescription
groupByColumnsString...

The column(s) by which to group data.

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

The column(s) by which to group data.

  • NULL returns only the last row in the table.
  • "X" will output the entire last row of each group in column X.
  • "X", "Y" will output the entire last 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 last row in the table.
  • "X" will output the entire last row of each group in column X.
  • "X", "Y" will output the entire last row of each group designated from the X and Y columns.

Returns

A new table containing the last row for each group.

Examples

In this example, lastBy returns the last row of the table.

In this example, lastBy returns the last row, as grouped by X.

In this example, lastBy returns the last row, as grouped by X and Y.